System Development, Software Updates, Quick Guides and Builder Training InformationBuilder Site Help Documentation Calculations and Table CalculationsTHIS 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

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)

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

You can make this the date override field if you require.

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

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

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

The correct day of the week is returned

0 Comments

Add your comment

E-Mail me when someone replies to this comment