Subject | EXTRACT(WEEK FROM DATE) - how to get the right year? |
---|---|
Author | Niko |
Post date | 2008-12-19T19:34:02Z |
Hi all,
I have seen the discussion in April about the correctness of the
EXTRACT(WEEK ...) function in FB 2.1.
On top of that I have a question: In some years, the last days of the
year part of the week of the next year. The EXTRACT() function works
correct in my understanding, but how can I associate the right year to it?
*) 28.12.2008 -> Week 52 of year 2008
*) 29.12.2008 -> Week 01 of year 2009
I am looking for a WeekOfTheYear() function. Maybe somebody has already
mastered this question.
The possibility to remove actualy redundant data (week of the year) and
replace it by a computed field is very tempting.
Thanks for help in advance
Niko
I have seen the discussion in April about the correctness of the
EXTRACT(WEEK ...) function in FB 2.1.
On top of that I have a question: In some years, the last days of the
year part of the week of the next year. The EXTRACT() function works
correct in my understanding, but how can I associate the right year to it?
*) 28.12.2008 -> Week 52 of year 2008
*) 29.12.2008 -> Week 01 of year 2009
I am looking for a WeekOfTheYear() function. Maybe somebody has already
mastered this question.
The possibility to remove actualy redundant data (week of the year) and
replace it by a computed field is very tempting.
Thanks for help in advance
Niko