0 Replies Latest reply on Apr 17, 2013 10:38 AM by The_Java_Junkie

    Using date calculations

    The_Java_Junkie

      Can anyone assist me with using date calculations please.

       

      I have a field (DT_WeekEnding) that the user will fill in (this is a Date/Time Field) based on the value in the date field I would like to calculate the other days of the week.

       

      DT_Sunday

      DT_Monday

      DT_Tuesday
      DT_Wednesday

      DT_Thursday

      DT_Friday

       

      If the saturday date = 04/06/2013

       

      DT_Sunday = 03/31/2013

      DT_Monday = 04/01/2013

       

      Etc.