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.