WEEKDAY( ) Returns the day of the week for a specified date value. Syntax WEEKDAY(date, option) Arguments date The date or date expression from which you get the day of the week. option A number representing the weekday format to return. Use one of the following values: 1 to get the day as a number from 1 (Sunday) to 7 (Saturday). 2 to get the day as a number from 1 (Monday) to 7 (Sunday). 3 to get the day as a number from 0 (Monday) to 6 (Sunday). 4 to get the full weekday name, for example, Wednesday. The result is locale-specific. 5 to get the abbreviated weekday name, for example Wed. The result is locale-specific. If you omit option, WEEKDAY( ) assumes option 1. Returns The day of the week for a specified date value. Example The following example gets the full weekday name for each date value in the DateSold data field: WEEKDAY([DateSold], 4)
© Copyright OpenText Corp. All rights reserved. Privacy Policy | Cookie Policy
