Extract year from year

[#1]

hi All,

I have a requirement, where in i should show week number extracting from year field.

In detail, week(year) should have list of 52 or 53  weeks of that particular year.

If i select, 2014, feb, week should display 5,6,7.

Quick response is appreciated.

Thanks in advance,

Smitha

[its_anandrjs · Accepted solution]

From this you get week

Week(YourDateField) as Week

Correct way is use Datefield for the different date field creation like

Year(YourDateField) as Year,

Month(YourDateField) as Month,

Week(YourDateField) as Week

Num(Month(YourDateField)) as NumMonth,

'Q' & ceil(month(YourDateField) / 3)  as Quarter

and so on

[MK_QSL]

Add below in your script...

Week(DateField) as Week

[rustyfishbones]

Try

Week(Date) as Week

[#5]

Thank you ☺

[#6]

thanks☺

[#7]

Thanks☺

[MK_QSL]

Close the thread by selecting correct/helpful answer.

[its_anandrjs]

Hi,

If you got correct answer so mark the thread as correct for the reference for others.

Regards