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)