Create a formula for the date:
  1. Select Insert, Field Object from the menu bar

  • Right-click Formula Fields and select New

  • Name the field Custom Date


  • The basis of the formula is the DayOfWeek function, which displays days as numbers. Sunday = 1, Monday = 2, etc.  This sample formula displays the date of the Monday of the current week:




    if DayOfWeek (CurrentDate) = 1

       then CurrentDate + 1

    else if DayOfWeek (CurrentDate) = 2

       then CurrentDate

    else if DayOfWeek (CurrentDate) = 3

       then CurrentDate - 1

    else if DayOfWeek (CurrentDate) = 4

       then CurrentDate - 2

    else if DayOfWeek (CurrentDate) = 5

       then currentdate -3

    else if DayOfWeek (CurrentDate) = 6

       then CurrentDate - 4

    else if DayOfWeek (CurrentDate) = 7

      then currentdate - 5


  • Click Save and Close to return to the report