topic Re. :Date Function to know Friday or Saturday or Sunday in QlikView

Date Function to know Friday or Saturday or Sunday

Fri, 14 May 2010 14:20:40 GMT

Hi,

Is anybody know the date function to get the date is Friday or Saturday or Sunday?

I could not find in Manual.

Thanks for your reply,

Qvsu

martin59 — Fri, 14 May 2010 14:26:16 GMT

Hello,

If you want to know the day of week, you have the WeekDay(Date) function.

Martin

Anonymous — Fri, 14 May 2010 14:28:48 GMT

If(weekday(Date)>3, 'Friday, Saturday or Sunday')

Fri, 14 May 2010 14:37:40 GMT

Thanks Michael and Martin.

Fri, 14 May 2010 14:54:16 GMT

Hi,

Again. I tried to check Weekday('2010-05-14') returns "Fri" instead of number.

Is it because of the my OS date setting or anywhere that I should check?

hector — Fri, 14 May 2010 14:56:01 GMT

Hi, it shows 'Fri', but internally is a number, you can check this with num(weekday(datefield))

Rgds

martin59 — Fri, 14 May 2010 14:57:55 GMT

You have an environment variable which format your data.

It is this line :

SET DayNames='lun.;mar.;mer.;jeu.;ven.;sam.;dim.';

If you prefer to see the numbers, you can convert to num like that :

num(WeekDay(Date))

Martin

Anonymous — Fri, 14 May 2010 18:55:33 GMT

Correct, it is dual, text AND number at the same time.
(Same about months.)