DateTime filter

Workflow Actions Pack Microsoft 365 version
1

Using GET ITEM BY QUERY command, I’m trying to filter items that have DueDate field before today; I want to extract items expired respect today.

How can I build filter condition?

thank you
Andrea

2

Hi,
Thank you for your message.

  1. You need to create a "Date/Time" variable by "Set Workflow Variable" and specify it by the current date (or specific date if you want)
  2. Format the date using specified format string. In "Get Items by Query" filter condition is using OData syntax and you need to format the date from your locale to the format for the datetime function in the filter condition. You may use "s" string format for date.
  3. Use "Get Items by Query" action with this formatted date in the filter condition.

You may find the example below:

DateFilter.png940×457 14.4 KB

Best regards
Evgeniy Kovalev
Plumsail Team