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
Thanks it work well the only other thing that I have to do is modified the script file.
In your load script, use the WeekDay() function.
LOAD Field1, Field2, ..., DateField, Year(DateField) as Year, Week(DateField) as Week, WeekDay(DateField) as WeekDay, Num(WeekDay(DateDield)) as NumWeekDayFROM Data.qvd (qvd);
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
Thanks but is in a Expression
Excuse me, but you do you means ?
I use the script in an expression like
=if(weekday(today()) = Dia ,Name)
What do you mean by "Dia" ?
Is your expression works ?
“Dia” means Day in Spanish and is a DB field, yes the expression works.
Ok sorry !
If the expression works, have you got another thing to resolve ?
Could you test:
0 - Monday
1 - Tuesday
6 - Sunday
Retrieving data ...