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!!

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

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

You could write a function for it.. do you use it in php or java or which context?

-Agarsia

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 1.18 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.