Display records since 26 hrs ago

[DianaStewart]

I am using CR 7.0

My report contains data for the school library. When I open my report I want to be able to display all the books that are taken out since 26 hrs ago. Example: I open my report on Wednesday at 7h30 am all the books since Tuesday at 5h30 am will be displayed... How can I do this? Any ideas?

Samuel

 

[goranm]

One way is to use the DateDiff function.
If you use the "n" argument for calculating minutes you can write like this in your Record Selection:

DateDiff (&quot;n&quot;,{table.DateTimeField} , CurrentDateTime) <= 1560

(26 hour = 1560 min)

/Goran