Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Show weekend days in a report - Crystal 8.5 1

Status
Not open for further replies.

gingerbagpuss99

Technical User
Jun 10, 2004
9
GB
I want a report to show contacts on a Saturday and Sunday over a 3 year period.

I am stuck trying to show only the contacts for Saturday and Sunday.

I am not very experienced with formulae so please forgive me if this is very basic. I have looked over some previous threads but have got a bit lost.

Many thanks for your help
 
In Crystal 8.5, you can get the day of the week by
Code:
DayOfWeek (date)
Put this in a formula field and test it. Saturday is 7 and Sunday is 1


Madawc Williams (East Anglia)
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top