Long Day Names

[#1]

Hi,

I'm having trouble getting the long day names function to work. I've set long day names as follows:

SET LongDayNames='Monday;Tuesday;Wednesday;Thursday;Friday;Saturday;Sunday';

Now I'm trying to query today using the following expression:

=weekday(now())

However this returns the short day name, not the long day name.

Any help would be appreciated.

Matt

[#2 · Accepted solution]

Hi

Try

=date(now(),'WWWW)

Regards

Anders

[#3]

Perfect!

Thanks for the help.

Matt