filtering get items based on date and time

(0) Share

Report

Posted on by Krishna98

204

Hi,

I'm Having a list as below,

now i want to filter the items based on date and startofhour. suppose now current time is 2020-11-1 8:30 PM so i want to compare upto hour in the current time and need to get the data t1 and t4.

so i've tried something like below,

Notify eq '2020-11-1 8'

outputs is formatted date i.e. 'yyyy-MM-dd HH' i.e. '2020-11-1 8'

Categories:

Using connectors

I have the same question (0)

All responses (4)

Answers (1)

Sort by

v-bacao-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @Krishna98 ,

You could paste the following expression to Filter Query to filter items:

Notify ge '@{utcNow('yyyy-MM-ddT00:00:00Z')}' and Notify lt '@{addDays(utcNow(),1)}'

Please take a try.

Best Regards,

Was this reply helpful? Yes No
Krishna98 204 on at

Like (0)

Report
Copy link

Link copied!

Hi @v-bacao-msft

i tried the same, i have ran at 11. so it should only give records whose notify time is 11. but it has also give the record whose
notify time is 9:00

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

Like (0)

Report
Copy link

Link copied!

Hi @Krishna98

If you want to compare up to an hour then use addHour expression.

addHours(utcNow(),1,'yyyy-MM-dd HH:mm:ss')

Thanks

Was this reply helpful? Yes No
Verified answer

v-bacao-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @Krishna98 ,

You could try this again:

Notify ge '@{utcNow('yyyy-MM-ddT00:00:00Z')}' and Notify lt '@{addDays(utcNow(),1,'yyyy-MM-ddT00:00:00Z')}'

Best Regards,

Was this reply helpful? Yes No