Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Pulling report for next 24 hours 1

Status
Not open for further replies.

honorbum

Technical User
Aug 26, 2005
50
US
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!
 
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
 
Try DateDiff("h", currentdate, {your.date}) > 0 and DateDiff("h", currentdate, {your.date}) <= 24

[yinyang] Madawc Williams (East Anglia, UK) [yinyang]
 
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.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top