Get Items and Date Filter

(0) Share

Report

Posted on by Ianhall1892

168

Hi,

I'm having issues with Date filter query with Get Items. I'm trying to bring back results based on a next review date. I'm trying to test on a particular date I know exists in the review date field in a Library. To do this I'm setting a variable with the following formula

utcNow('2022-05-14') and the set the query to Next_x0020_Review_x0020_Date eq 'variable'

This does not return any results however I can get a result with utcNow('2019-08-08').

Any tips on what I'm doing wrong would be great as its driving me mad.

Categories:

Building flows

I have the same question (0)

All responses (7)

Answers (0)

Sort by

Pstork1 69,205 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
utcnow() doesn't take a specific date as the parameter. It takes a date format like this

utcNow('yyyy-MM-ddTHH:mm:ss')

If you want a future date then you need to use FormatDateTime and AddDays something like this

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

This would give you a date 22 days in the future from now.

Was this reply helpful? Yes No
Ianhall1892 168 on at

Like (0)

Report
Copy link

Link copied!

If I test the get items filter with this query I get the relevant document back
Next_x0020_Review_x0020_Date eq '2019-08-08'

I test with Next_x0020_Review_x0020_Date eq '2022-05-14' I don't get a result back even though that date exists int he Library. So I'm puzzled whilst one query works but the other one dosen't

Was this reply helpful? Yes No
Pstork1 69,205 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Try testing with Next_x0020_Review_x0020_Date eq '2022-05-13' . You could be running into an issue with time conversion. Remember time and date fields are stored with a time component even if they are set for Date only.

Was this reply helpful? Yes No
Ianhall1892 168 on at

Like (0)

Report
Copy link

Link copied!

Its seems on this particular site some items wont filter without having the time portion adding to the query which frustrating because how can you set a date wit the exact time portion. Amending the date either side of the date dosen't work either

Was this reply helpful? Yes No
Pstork1 69,205 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

To get a specific date that contains a time portion you'll need to test whether its greater than yesterday at midnight and more than today at midnight.

Was this reply helpful? Yes No
Ianhall1892 168 on at

Like (0)

Report
Copy link

Link copied!

Hi thats what ive basically done

Was this reply helpful? Yes No
Pstork1 69,205 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Could you show us your code? The sample you pasted in a previous reply is using eq (Equals)

Was this reply helpful? Yes No