Share
Report
125Hi All,
I am trying to 'get items' from a SharePoint list where the today's date is 8 days post the SharePoint date.
I have set the following variable
to get my query control. This is working i.e. on the 21/03/2024 its returning 13/03/2024
Then I have a get items from my SharePoint list with the following criteria
This is returning 1 item with a reviewMeetingDate = 12/03/2024. I think this is to do with a timezone issue and Sharepoint storing values as UTC but I can't quite work out how I work around it. I tried 'convert time zone' my varDate8DaysPost to UTC but still returns 13/03/2024 and get items brings back dates of the 12/03/2024
What am I doing wrong, on a side note my date field on my sharepoint list is set as date/time but for my query I don't care about the time just the date.
Thanks
All responses (
Answers (
