Calculate day of the week from a date field

Add in a Date field (e.g. Selected Date, or use Event Date)

Add in a Date field (e.g. On Date or Start Date)

Add in a Text Calculation to the format the date field: dateformat(Selected Date, "EEE").

Add in a Text Calculation to return the Date Field. This will be set to be hidden in the Event form.

Now add in a Option Calculation with Mon to Sun as Options and the equation list below.

Now add in a Option Calculation with Monday to Sunday as Options and the equation list below. This field should not be set to be hidden

The equation in the image in the example here uses partial day names

if(Day = "Mon","Mon",

if(Day = "Tue","Tue",

if(Day = "Wed","Wed",

if(Day = "Thu","Thur",

if(Day = "Fri","Fri",

if(Day = "Sat","Sat",

if(Day = "Sun","Sun")))))))

The correct day of the week is returned

The correct day of the week is returned

Note, the image here show the old oldated workflow returning the wrong day!

Note, the image here show the old oldated workflow returning the wrong day!

0 Comments

Add your comment

E-Mail me when someone replies to this comment