cancel
Showing results for 
Search instead for 
Did you mean: 

To calculate last 24 hrs Data

Former Member
0 Kudos

Hello,

Can someone provide me the syntax for generating a report for the 'last 24 hrs' and last 72 hrs'.

Thanks

Regards

Cauvery

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi,

I will try something like this:

Datediff("h",DateA,CurrentDate)<=24
Datediff("h",DateA,CurrentDate)<=72

Hope this helps.

Former Member
0 Kudos

Thanks Greg. It worked!

Regards

Cauvery