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
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