Formula current full day 1

[Tbrandes]

In Crystal 8.5... I,m needing to get the current full running day data from Midnight. Can someone straighten me out on the formula code used?? I have users wanting to run this report daily at each hour so they can update a Daily Stat Board at our Call Center.

Thanks in advanced
Tedd

 

[dgillz]

Please define what you mean by "the current full running day data from Midnight".

Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports

http://www.trianglepartners.com

 

[Tbrandes]

We have a 24 hour Call Center. Each hour they upate a Stat Board. I'm compiling a report from my Nortel Symposium Server that they can run each hour for stats. So they will run it at 0100 0200 0300 etc. I'm looking for the formula that will give them the data from midnight of that day to the current run time 24 times a day. Hope that explained it.

 

[lbass]

If the end time is always the run time, then I think you could use a record selection formula like:

{table.datetime} >= currentdate

If you want to make sure the data is only being read through the most recent hour, then change it to:

{table.datetime} in currentdate + time(0,0,0) to currentdate + time(hour(currentdatetime),0,0)

-LB