Unanswered

OData filter query - get anything prior to today

(1) Share

Report

Posted on by admind365

Hi, I need to get any records where the date is earlier than today's date. The time shouldn't matter. If it was yesterday at 11:59:59 pm, the record should still end up in the results from this query. My current query below appears to get anything in the past, including anything earlier today. How do I get anything from yesterday and prior to yesterday? I'm stuck on this one....

Categories:

General topics

I have the same question (0)

All responses (5)

Answers (1)

efialttes 14,756 on at

Like (1)

Report

Hi
Is this odata filter sharepoint based?
BR

Was this reply helpful? Yes No
admind365 20 on at

Like (1)

Report

It's in MS Automate for D365. Not related to SharePoint.

Was this reply helpful? Yes No
Verified answer

efialttes 14,756 on at

Like (1)

Report

Hi
Have you considered using the following instead?
StartOfDay(utcNow())

Was this reply helpful? Yes No
admind365 20 on at

Like (2)

Report

That appears to have worked! Thank you--didn't know that function existed!

Was this reply helpful? Yes No
efialttes 14,756 on at

Like (1)

Report

Hi
This link covers all currently supported functions, hope it helps in the future:

https://docs.microsoft.com/en-us/azure/logic-apps/workflow-definition-language-functions-reference

Happy Flowing!

Was this reply helpful? Yes No