Pulling report for next 24 hours 1

[honorbum]

New to Crystal - need a formula for pulling reports based on a date/time field in Remedy for the next 24 hours or from 6am to 6am next day. Please help!

 

[jdemmi]

You could use the "today" or "currentdate" function (preferred)

like

{TABLE.DATEFIELD} = today + 1

or

{TABLE.DATEFIELD} = currentdate + 1

But I do not think this will take into account hours.

-- Jason
"It's Just Ones and Zeros

 

[Madawc]

Try DateDiff("h", currentdate, {your.date}) > 0 and DateDiff("h", currentdate, {your.date}) <= 24

Madawc Williams (East Anglia, UK)

 

[honorbum]

currentdate +1 worked. I had tried that once already but it didn't work. Once I deleted everything and started from scratch, it worked. Thank you.