Date Function to know Friday or Saturday or Sunday

[#1]

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]

Hello,

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

Martin

[Anonymous · Accepted solution]

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

[#4]

Thanks Michael and Martin.

[#5]

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]

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

Rgds

[martin59]

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]

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