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'

All responses (1)

Answers (1)

Verified answer

v-bacao-msft on at

Like (0)

Report
Re: filtering get items based on date and time

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,