topic Extract Dayname . in QlikView

Extract Dayname .

Wed, 16 Oct 2013 11:09:27 GMT

hi,

how to extract dayname like monday, tuesday etc. from reloadtime.

Regards,

Piyush Jain

tresB — Wed, 16 Oct 2013 11:16:33 GMT

You can try WeekDay() function. And set daynames in the script like:

SET DayNames='Monday;Tueday;Wedday;Thuday;Friday;Satday;Sunday';

israrkhan — Wed, 16 Oct 2013 11:17:21 GMT

hi,

Use This one.

='Last Reload Date : ' & date(ReloadTime(), 'DD/MM/YYYY') &' ' & weekday(ReloadTime()) &' '&TIME(ReloadTime(),'hh:mm:ss')

hope it helps..

CELAMBARASAN — Wed, 16 Oct 2013 11:55:06 GMT

You can get it by using

Text(Date(ReloadTime(), 'WWWW'))