The fields I'm working with are Acc 1

[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

 

[paulmarr]

ecugrad,

You would write something like this - and use the formula in the record selection.

DayofWeek({dbfield.AccountDate})in [2,3,4,5,6] and Time({dbfield.AccountDate})>= 06:00:00 and Time({dbfield.AccountDate})<= 18:00:00

DayofWeek function returns a number from 1 to 7 (Sunday to Saturday) and Time(DateTime) returns the time in military format.

Hope this helps you.

Cheers,

paulmarr@arcom.com.au