THIS METHOD IS NO LONGER SUPPORTED AND IT IS CONFIRMED NOT TO BE A RELIABLE METHOD TO RETURN DAY OF THE WEEK. SEE THE NEXT HELP MANUAL DOCUMENT: A method to calculate day of the week from a date field
Add in a Date field (e.g. On Date or Start Date)
You can make this the date override field if you require.
Add in a Text Calculation to return the Date Field. This will be set to be hidden in the Event form.
Add in a Calculation with the equation listed below. This field will be set to be hidden in the Event form.
(((Date Value - 820450800000)/86400000)/7 - floor(((Date Value - 820450800000)/86400000)/7))*7+1
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 Number = 1,"Mon",
if(Day Number = 2,"Tue",
if(Day Number = 3,"Wed",
if(Day Number = 4,"Thur",
if(Day Number = 5,"Fri",
if(Day Number = 6,"Sat","Sun"))))))
You can use the full names if you require, just update your options correctly.
if(Day Number = 1,"Monday",
if(Day Number = 2,"Tuesday",
if(Day Number = 3,"Wednesday",
if(Day Number = 4,"Thursday",
if(Day Number = 5,"Friday",
if(Day Number = 6,"Saturday","Sunday"))))))
The correct day of the week is returned
0 Comments
Add your comment