Week

[#1]

Hi Experts,

I have one column data  like ....

Day

01 mar

02mar

03 mar

04mar

05 mar

06 mar

07 mar

08 mar

09 mar

10 mar

11 mar

12 mar

13 mar

14 mar

15 mar

16 mar...........................

Here  i need week numbers.

[MarcoWedel]

If you do not have the year information within your data then please specify the week number definition you want to use in this case to get unambiguous results.

Iso-weeks e.g. vary for the same day/month within different years:

hope this helps

regards

Marco

[#3]

Thanks all  to sharing information,

finally I got output

[tyagishaila]

Its good,

share solution with us.

for which year you get weeks?

[#5]

Hi tyagishaila,

i tried like this

week(DATE(DATE#(fieldname,'DD MMM'),'MM/DD')) 

[MarcoWedel]

Please close your thread by selecting a correct answer

Thanks

Regards

Marco

[tyagishaila]

Well Done.

but as you have some Day's values are like

02mar

04mar

means not follow 'DD MMM' format.. those values will be missed.

Hi Experts,

I have one column data  like ....

Day

01 mar

02mar

03 mar

04mar

05 mar

06 mar

07 mar

08 mar

09 mar

10 mar

11 mar

12 mar

13 mar

14 mar

15 mar

16 mar......

or it type by mistake. I considered that your Day field is string without any common format.

[#8]

Hi tyagishaila,

I have data format in column like 'DD MMM' only.

Thanks,