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 Text Calculation to the format the date field: dateformat(Selected Date, "EEE").

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

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

0 Comments
Add your comment