Skip to Content
avatar image
Former Member

How to process for a Friday /Saturday

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.?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Dec 22, 2016 at 08:46 PM

    There is a function in Crystal Reports

    DayOfWeek (date)

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

    Add comment
    10|10000 characters needed characters exceeded