Expand my Community achievements bar.

Using date calculations

Avatar

Former Community Member

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.

0 Replies