date display

[#1]

Hi

I need to display YY Week to create a trend spanning many years. I can display

Date(MonthStart([Date Inserted]),'YY MM') as MonthStart, >> as means to display the year and month.

I need the equivalent to display week e.g. 13 42  Year Week No

Please assist.

Fanie

[rustyfishbones]

Try this

Week(weekstart([Date Inserted])  & '-' & WeekYear([Date Inserted]) )  as YearWeek

[hic]

Dual(WeekYear([Date Inserted]) & '-W' & Week([Date Inserted]), WeekStart([Date Inserted]))

HIC

[#4]

Hi,

I think you can concatenate two value for this  result.

Year([Date Inserted]) & ' ' & Week([Date Inserted]) as YearWeek

Hope this help you

Regards,

Ashutosh

[#5]

Hi Alan

Nope - not doing it. But thanks - I'm trying all variations.

Regards

Fanie

[MayilVahanan]

Hi

Try like this too..

Date([Date Inserted] ,'YY') & Week([Date Inserted]) AS YearWeekNo

[#7]

Ashutosh

Works like a charm.

Great  - thank you.

Fanie