Avatar

Employee Advisor

Hi Dev,

Let me check on this function definition code .

 

Please find below how weekday works:

 

WeekDay(date/datetime)

Returns the number of day in the week following the rule: 0=Monday ...
6=Sunday.

 

In case argument is of type datetime - day of the week is calculated from time in client's timezone (timezone is passed to server in query). Otherwise, if argument is of type date, day of the week is calculated in timezone agnostic manner.

 

Example

WeekDay(#2021-09-22 00:34:56Z#)=2