Get the Week Day Name from a date stored in a table... 1

[SQLBI]

Hi,

Access VBA includes a WeekDayName function:

WeekdayName(Weekday(dteDate))

which returns Sunday to Saturday depending on the date parameter.

I've tried to use this in a JET SQL statment and it is not a vilid function.

Is there a JET function which will do the same thing and if so could someone please let me know the syntax.

Thanks in advance.


Leigh Moore
Solutions 4 MS Office Ltd

http://www.solutions4msoffice.co.uk

 

[TonyJollans]

Hi Leigh,

You can use Format(Yourdate, "dddd&quot.

Enjoy,
Tony

 

[SQLBI]

Thanks Tony.





Leigh Moore
Solutions 4 MS Office Ltd

http://www.solutions4msoffice.co.uk