Skip to Content
0
Former Member
May 15, 2009 at 04:14 PM

Automate report with reference period within the last 24 hours

93 Views

Please help, I need to automate a report so that the time period that is covered is within the last 24 hours. Any suggestions? Here's what I have been provided, but have been getting errors. I have had little experience with Crystal Report writing. Would appreciate any suggestion.

{Incident.Close Date & Time} in {@StartDateTime} to {@EndDateTime}

StartDateTime =

DateAdd ("h", -24, datetimevalue(datadate & " " & datatime))

EndDateTime=

datetimevalue(datadate & " " & datatime)