Day of a Date if Moday as first day of week

[dkma]

Hello all,

How to find the day of a Date if the week starts on Monday

[apathetichell · Accepted solution]

datetimeformat([date],"%u") gives you monday as 1 day of the week.

datetimeformat([date],"%a") will give you 3 letter weekday abbreviation

[dkma]

Consider Monday is the First day of the week

[apathetichell · Accepted solution]

datetimeformat([date],"%u") gives you monday = 1.