yearweekfromdate function starts on tuesday

mmartin · Post by **mmartin** » Tue Mar 05, 2013 12:48 pm

I'm facing an issue using the yearweekfromdate function in a PX transformer.
My job uses a row generator in input to generate incremental dates.

I want to catch the week number for each date but it seems that this function returns tuesday as the first day of the week (monday is day 0 and tuesday is day 1).

What is very strange is that using the function weekdayfromdate, the first day of the week is set to sunday which is day 0.

Does anybody knows if it is a platform setting issue or anything wrong in my use of these functions?

Thanks for your precious answers.

jwiles · Post by **jwiles** » Tue Mar 05, 2013 1:44 pm

Perhaps YearWeekFromDate's results are based upon a week starting on the weekday of the first day of the year being examined? So, if the year started on a Wednesday, then you would see the week number advance on every Wednesday of that year.

Simply a hypothesis: I don't have access to a DS server at the moment to verify.

Regards,

mmartin · Post by **mmartin** » Wed Mar 06, 2013 11:02 am

It was because the first day of the year is a tuesday that's right!

Thanks for your precious help.