Want to retrieve all objects where the day of the week is a Thursday

0
Hi,   I am struggling to work out how to retrieve, on a datagrid, all objects where the LastPlayed date is a Thursday. I have tried the xpath constraint.   [dayOfWeek(LastPlayed) = 4]   I have tried the above but it comes up with an unknown function, thanks so much.
asked
1 answers
0

Jessica,

I think the function you should use is weekday-from-datetime(), like this:

[weekday-from-dateTime(LastLogin) = 5]

 

Note that this function returns a day number with 1 being Sunday, so Thursday would be 5.

 

Hope that helps,

Mike

answered