I am using the Action Get Files (properties only) for SharePoint to query all Site Pages published in the last 24 hours, but for some reason, its grabbing more like the last 26-30 hours.. basically anything with todays date or yesterdays and I cannot figure out why.
The query I am using is getting FirstPublishedDate greater than or equal to utc time now a day ago AND if it was published (PromotedState of 2:
(FirstPublishedDate ge '@{formatDateTime(addDays(convertFromUtc(utcNow(),'Central Standard Time'),-1),'yyyy-MM-ddThh:mm:ssZ')}') and (PromotedState eq '2')
also this does not work
(FirstPublishedDate ge '@{formatDateTime(addDays(-1),'yyyy-MM-ddThh:mm:ssZ')}') and (PromotedState eq '2')
I also tried just getting the last 24 hours
(FirstPublishedDate ge '@{formatDateTime(addHours(-24),'yyyy-MM-ddThh:mm:ssZ')}') and (PromotedState eq '2')
Any thoughts to why when it runs every day at noon, it also includes stuff from yesterday morning (BEFORE noon). thanks!
