Unanswered

To compare date

(0) Share

Report

Posted on by Community Power Pla...

Hi,

I'm trying to build a flow, in which I'm using Filter query in get items step. I'm trying to compare date column in SharePoint list if it is equal to today's date. But the flow is returning no results. Kindly help.

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (0)

abm abm 32,858 Most Valuable Professional on at

Like (0)

Report

Hi @Anonymous

Use the below format

formatDateTime(utcNow(), 'yyyy-MM-dd')

or

formatDateTime(utcNow(), 'MM-dd-yyyy')

I can see below there are two single quotes. The format expression should be between the single quotes.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

The problem is if I give formatDateTime(utcNow(), 'MM/dd/yyyy'). It's adding zero before the date and not getting the data.

Was this reply helpful? Yes No
abm abm 32,858 Most Valuable Professional on at

Like (0)

Report

Hi @Anonymous

I always use yyyy-MM-dd format. I have made a tutorial video about this.

https://www.youtube.com/watch?v=FRKtB37hJ4g&t=39s

Please have a look.

Thanks

Was this reply helpful? Yes No