Get the Full Day Name

[rustyfishbones]

Hi All

I have used the following to get the full Month name and it works

=DATE(RELOADTIME(),'MMMM') the result is April not Apr

I have tried the following to get the Full Day Name

=WEEKDAY(RELOADTIME()) and the result I get is Sun, but I am looking for a result of Sunday

Can you help?

Alan

[#2]

try to change

SET DayNames='Mo';'Tue'.....

to

SET DayNames='Monday';'Tuesday'.....

in Your load script

[#3]

Hi,

In the loadscript there is something like

SET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun';

Change this to

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

This is affected after a reload.

Cheers

[rustyfishbones · Accepted solution]

Thanks All, but I received the answer and made a video

DATE(DateField),'WWWW') will give the full dayname without changing the SET.

A good example is

DATE(RELOADTIME(),'WWWW')

Check this Video as it may help

http://youtu.be/gol5llXgDWw

Regards

Alan

[er_mohit]

Try This

=Date(RELOADTIME(),'WWWWW')