Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try this
Week(weekstart([Date Inserted]) & '-' & WeekYear([Date Inserted]) ) as YearWeek
Dual(WeekYear([Date Inserted]) & '-W' & Week([Date Inserted]), WeekStart([Date Inserted]))
HIC
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
Hi Alan
Nope - not doing it. But thanks - I'm trying all variations.
Regards
Fanie
Hi
Try like this too..
Date([Date Inserted] ,'YY') & Week([Date Inserted]) AS YearWeekNo
Ashutosh
Works like a charm.
Great - thank you.
Fanie