Date Range

[Rosy1]

I want to create a report looking at data from yesterday at a particular time and ending today at a particular time. Can anyone help me going over the midnight barrier?
Thanks... Rosy1

 

[lbass]

Try something like the following for your record selection formula:

{table.datetime} in datetime(currentdate-1,time(19,0,0)) to datetime(currentdate,time(18,59,59))

-LB

 

[synapsevampire]

Another means would be to create a datetime parameter of type range, and then the report will prompt you for the range.

Then your record selection formula->record would have:

{table.datetime} in {MyDateTimeParameter}

-k