Fiscal week number as a date range

[User12321]

Hello,

I want to create a field in the load script that represents the fiscal week number as a date range using the minimum billing date for each week as the lower bound and maximum billing date for each week as the upper bound.

Any suggestion is greatly appreciated. Thanks.

[MayilVahanan · Accepted solution]

HI 

If you select the Fiscalweek in front end, you will get the date range. 

Suppose, if you want in new field in script , try like below

Join(Calendartablename)

Load FiscalWeek, Date(Min(BillingDate))&'-'&Date(Max(BillingDate)) as NewFieldName resident calendartablename 

group by FiscalWeek;