Fiscal Year and Fiscal Week converted to Fiscal Year Week

[bobbydave]

MapDateToFiscalWeek:

Mapping

LOAD Date,

    Date(Date#(Fiscal_Year & Fiscal_Week,'YYYYWW'),'YYYYWW') as YearWeek

FROM

[$(vQVDs)\T_Calendar_Test.qvd](qvd);

I understand now that YYYYWW is now Year & Weekday and not Week#.

Is there a way to convert Fiscal Year and Week to YYYYWW as in Week?         

[sunny_talwar]

How about this

Fiscal_Year*100 + Fiscal_Week as YearWeek

[its_anandrjs]

Try this

Left(Fiscal_Year,4) & Fiscal_Week as YearWeek

[its_anandrjs]

Or may be

Date(Date#(Left(Fiscal_Year,4),'YYYY'),'YYYY') & Fiscal_Week as YearWeek

Or

Year(Date#(Left(Fiscal_Year,4),'YYYY')) & Fiscal_Week as YearWeek