Answered

Get Items w/Filter Query Not Working

(0) Share

Report

Posted on by LaMakiry

Please help! I am trying to "Get Items" that were created today. I think I have tried everything but for some reason, it is not grabbing anything from the list. I've tried:

Changing the "Filter Query" expression (current is

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

Settings -->Pagination (5000)Limit
Columns by View --> Use all columns (Do not limit)

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

grantjenkins 11,059 Moderator on at

Like (1)

Report
Re: Get Items w/Filter Query Not Working

Created will include both a Date and Time, so it will never match just a Date.

You will need to check if Created is greater or equal to start of today, and less than start of tomorrow. You can just copy/paste the following expression directly into your Filter Query.

Created ge '@{startOfDay(utcNow())}' and Created lt '@{startOfDay(addDays(utcNow(), 1))}'

----------------------------------------------------------------------
If I've answered your question, please mark the post as Solved.
If you like my response, please consider giving it a Thumbs Up.

Was this reply helpful? Yes No
LaMakiry 92 on at

Like (0)

Report

Re: Get Items w/Filter Query Not Working

Thank you! Worked perfectly.

Was this reply helpful? Yes No