2 Replies Latest reply on Apr 21, 2015 12:36 PM by RickDearden

    Conditionally formatting weekend dates

    RickDearden

      Title

      Conditionally formatting weekend dates

      Post

      Hi guys,

      I have a report which shows timesheet entries.

      What I would like to do is highlight each line who's Date is a Saturday or a Sunday.

      The screenshot shows my layout and fields.

      I have tried using:

      Timesheets:Date = DayOfWeek ( 1 )

      and the same for Sunday ( 7 ) in the Conditional format Formula field but this doesn't work.

      Any ideas?

      Thanks in advance :-)

      Rick.

      Capture.JPG