DateTime Formula/Question

[ecugrad]

The fields I'm working with are AccountNumber, EndTime(datetime) and StartTime(datetime)in CR8. I been tasked to write a weekly report that will display the number of Accounts that have been indexed from M-F between 0600 and 1800. I would appreciate any suggestions on how to write this. I'm still pretty much a newbie on writing formulas.

Thanks

 

[kenhamady]

It would be something like:

If DayOfWeek({StartTime}) in 2 to 6
and Hour({StartTime}) in 6 to 18
then 1
else 0

Sum of this field would tell you how many qualified.

If this isn't it, what exactly does:
"indexed from M-F between 0600 and 1800"
mean in terms of start time and end time?
Ken Hamady, On-site/Phone Crystal Reports Training/Consulting
Quick Reference Guide to using Crystal in VB

http://www.kenhamady.com/