Hi,
I want the week of the year, given a date. I used YEARWEEK('1987-01-01') which return me 198653, but i want it 198701 as the output which means the year and the week number of that year.
How to do this...
Thanks in advance!!
divyakprabh
0
Light Poster
Recommended Answers
Jump to PostMaybe because the first of January is in the last week of the year before (1986) for example its an friday. then the first week of 1987 starts at the 4. of January.
-Agarsia
All 4 Replies
Agarsia
0
Junior Poster
Maybe because the first of January is in the last week of the year before (1986) for example its an friday. then the first week of 1987 starts at the 4. of January.
-Agarsia
divyakprabh
0
Light Poster
Yes, but cant i have some customization such that it returns me as expected.
Maybe because the first of January is in the last week of the year before (1986) for example its an friday. then the first week of 1987 starts at the 4. of January.
-Agarsia
Agarsia
0
Junior Poster
You could write a function for it.. do you use it in php or java or which context?
-Agarsia
divyakprabh
0
Light Poster
I use it in java
You could write a function for it.. do you use it in php or java or which context?
-Agarsia
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.