Get day number from week

[#1]

Hi I’m struggling getting the number of the day from a week. In a Expression

Example 16/01/2013 is Wednesday that is a 3; a Monday would be a 1 and so on.

Thanks in advance

[danielrozental]

Try weekday(Datefield)

[martin59]

Hi,

In your load script, use the WeekDay() function.

For example,

LOAD Field1,

     Field2,

     ...,

     DateField,

     Year(DateField) as Year,

     Week(DateField) as Week,

     WeekDay(DateField) as WeekDay,

     Num(WeekDay(DateDield)) as NumWeekDay

FROM Data.qvd (qvd);

Hope that helps you

Martin Favier

[#4]

Thanks it work well the only other thing that I have to do is modified the script file.

[#5]

Thanks but is in a Expression

[martin59]

Excuse me, but you do you means ?

Martin Favier

[martin59]

Excuse me, but you do you means ?

Martin Favier

[martin59]

Excuse me, but you do you means ?

Martin Favier

[#9]

I use the script in an expression like

=if(weekday(today()) = Dia ,Name)

[martin59]

What do you mean by "Dia" ?

Is your expression works ?

Martin Favier