Day of week = Sunday

[rmiller11]

I would like to get hours for a date range and only want the hours that were worked o Sunday.
Ie: if datefield = Sunday then hoursWorked

How would I do that?

 

[Naith]

If DayOfWeek({YourDate}) = 1
Then HoursWorked

 

[Madawc]

In Crystal 8.5, you can test:

if DatePart("w", {datefield}) = 1

Sunday is day 1, in this system.

Madawc Williams
East Anglia, Great Britain

 

[synapsevampire]

If it's for a date range, then try adding the following to Report->Edit Selection Formula:

DayOfWeek({YourDate}) = 1

You might be better served to offlaod this processing to the database, but you'll have to post technical information such as Crystal version and database used if you want specific answers.

-k