topic Re: DayFunction in QlikView

DayFunction

vanderson009 — Sat, 24 Aug 2013 13:11:47 GMT

Hi Community,

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

Then, how could i display????

Thanks

Villyee

rajeshvaswani77 — Sat, 24 Aug 2013 13:28:01 GMT

Hi Villyee

Try this.

=Date(today(),'WWW')

for three letters

=Date(today(),'WWWWWW')

for displaying the full weekday ex: Saturday

thanks

-RV

jagan — Sat, 24 Aug 2013 13:28:27 GMT

Hi,

Try like this

=weekday(Today())

Output : Sat

Regards,

Jagan.

Sat, 24 Aug 2013 14:28:49 GMT

Just use

WeekDay(Date)

er_mohit — Sat, 24 Aug 2013 14:41:41 GMT

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