Skip to Content
0

How to process for a Friday /Saturday

Dec 22, 2016 at 07:30 PM

24

avatar image

I have an appointment date column. which is a typical SQL server datetime col.

I need to report on any appoints that occurred on a Friday or a Saturday.

How can I get this in a formula.?

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Vitaly Izmaylov
Dec 22, 2016 at 08:46 PM
0

There is a function in Crystal Reports

DayOfWeek (date)

If result of the function equals 5 then it is Friday and 6 for Saturday

Share
10 |10000 characters needed characters left characters exceeded