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
In your load script, use the WeekDay() function.
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