DayFunction

[vanderson009]

Hi Community,

Suppose i have date but i want to display Day for that respective Date.

Then, how could i display????

Thanks

Villyee

[rajeshvaswani77 · Accepted solution]

Hi Villyee

Try this.

=Date(today(),'WWW')

for three letters

=Date(today(),'WWWWWW')

for displaying the full weekday ex: Saturday

thanks

-RV

[jagan]

Hi,

Try like this

=weekday(Today())

Output : Sat

Regards,

Jagan.

[#4]

Just use

=

WeekDay(Date)

[er_mohit]

Try this function if you want complete DayName like Sunday then try this

Date(Datefield,'WWWW') as FullDayName

or if you want as alike your default dayname like sun,mon

then

WeekDay(Datefield) AS CalendarDayName

hope it helps