-
weekday
To return the weekday of a given date value as a number With this function, you can determine the corresponding weekday from a date value. The weekday is a number with Monday = 0, Tuesday = 1, ...…
-
weekdayIndex
To return a given weekday name as a number With this function, you can determine the corresponding weekday as a number from a weekday name. The weekday is a number with Monday = 0, Tuesday = 1, ...…
-
weekdayName
To return the full weekday name of a given date value With this function you can determine the corresponding weekday as a string from a weekday number with 0 = Monday, 1 = Tuesday, … 6 = Sunday.…
-
workdays
To return the number of working days between 2 given dates With this function, you can calculate the number of working days between 2 given time-related values, with Monday to Friday as working days.…
-
year
To return the year of a given date value This function provides the year from a date value as a number. You can use this function when calculating year numbers as well as filtering, sorting,…
-
yearmonth
To return the month and the year of a given date value You will get the year and month from a given date value displayed in the format "YYYY/MM". This can help you filtering, sorting,…
-
yearquarter
To return the quarter and the year of a given date value You will get the year and quarter from a given date value displayed in the format "YYYY Q1." This can help you filter, sort, and group records.…
-
yearweek
To return the week and the year of a given date value You will get the year and the week from a given date value, displayed in the format "YYYY WW." This can help you filter, sort, and group records.…