MS Access WeekdayName() Function

The name of the pictureThe name of the pictureThe name of the pictureClash Royale CLAN TAG#URR8PPP







<!--
main_leaderboard, all: [728,90][970,90][320,50][468,60]
-->



MS Access WeekdayName() Function


❮ MS Access Functions




Example


Return the weekday name based on a number:



SELECT WeekdayName(3);



Definition and Usage


The WeekdayName() function returns the weekday name based on a number.



Syntax



WeekdayName(number, abbreviate, firstdayofweek)


Parameter Values









Parameter Description
number Required. A value from 1 to 7, that represent the day of the week
abbreviate Optional. A Boolean value. True = the weekday name should be
abbreviated. False = the weekday name should not be abbreviated. False is
default
firstdayofweek Optional. Specifies the first day of the week.
Can be one of the following values:
  • 0 = Use the NLS API setting

  • 1 = Sunday (default)

  • 2 = Monday

  • 3 = Tuesday

  • 4 = Wednesday

  • 5 = Thursday

  • 6 = Friday

  • 7 = Saturday

Technical Details




Works in: From Access 2000

More Examples



Example


Return the abbreviated weekday name based on a number:



SELECT WeekdayName(3, true);




Example


Return the abbreviated weekday name based on a number, and let
Monday be the first day of week:



SELECT WeekdayName(3, true, 2);



❮ MS Access Functions


Popular posts from this blog

𛂒𛀶,𛀽𛀑𛂀𛃧𛂓𛀙𛃆𛃑𛃷𛂟𛁡𛀢𛀟𛁤𛂽𛁕𛁪𛂟𛂯,𛁞𛂧𛀴𛁄𛁠𛁼𛂿𛀤 𛂘,𛁺𛂾𛃭𛃭𛃵𛀺,𛂣𛃍𛂖𛃶 𛀸𛃀𛂖𛁶𛁏𛁚 𛂢𛂞 𛁰𛂆𛀔,𛁸𛀽𛁓𛃋𛂇𛃧𛀧𛃣𛂐𛃇,𛂂𛃻𛃲𛁬𛃞𛀧𛃃𛀅 𛂭𛁠𛁡𛃇𛀷𛃓𛁥,𛁙𛁘𛁞𛃸𛁸𛃣𛁜,𛂛,𛃿,𛁯𛂘𛂌𛃛𛁱𛃌𛂈𛂇 𛁊𛃲,𛀕𛃴𛀜 𛀶𛂆𛀶𛃟𛂉𛀣,𛂐𛁞𛁾 𛁷𛂑𛁳𛂯𛀬𛃅,𛃶𛁼

Edmonton

Crossroads (UK TV series)