Filtering last hour data

(0) Share

Report

Posted on by Lebo33

Good day

am trying to filter last hour data from SQL data using the following expression but it's not really working as it only extract everything that was loaded today

formatDateTime(addHours(utcNow(),-1),'yyyy-MM-ddT00:00:00Z')

Categories:

General topics

I have the same question (0)

All responses (6)

Answers (0)

v-yetonggu-msft on at

Like (0)

Report
Copy link

Link copied!
Hi @Lebo33 ,

Please try this expression:

addHours(utcNow(),-1,'yyyy-MM-ddTHH:mm:ssZ')

Best Regards,

Sunshine Gu

Was this reply helpful? Yes No
Lebo33 10 on at

Like (0)

Report
Copy link

Link copied!

Hi
i tried it, still does the same

Was this reply helpful? Yes No
v-yetonggu-msft on at

Like (0)

Report
Copy link

Link copied!

Hi @Lebo33 ,

Could you go to the editing interface and post a screenshot of the Action you wrote the expression?

Best Regards,

Sunshine Gu

Was this reply helpful? Yes No
Lebo33 10 on at

Like (0)

Report
Copy link

Link copied!

Was this reply helpful? Yes No
MrGott 101 on at

Like (0)

Report
Copy link

Link copied!

you dont need to wrap date() around your column and expression

yourdatecolumn ge @{formatDateTime(addHours(utcNow(),-1),'yyyy-MM-ddT00:00:00Z')}

Was this reply helpful? Yes No
Lebo33 10 on at

Like (0)

Report
Copy link

Link copied!

Hi
if i don't wrap it up, am not getting any output.

Was this reply helpful? Yes No