Date Conversion

[dcates]

Hi,

I've been hunting through the boards and don't see a solution to my problem. There were similar but they don't answer my needs, as far as I can tell. I'm using the TS ARIMA and ETS tools for forecasting. The forecast gives me the Period and Sub_Period for the dates. I'm using the Covariate Forecast. Before the data goes through the forecast, I run the dates through the DateTime tool. I get the below period and subperiod. Other posts have said the period is the week and subperiod is the day of the week. I understand the subperiod as the day but what is the period? Is there a tool I'm missing that can convert this back to the date? Thanks for the help!

[gautiergodard]

@dcates 
Period is week (%U variable in date conversion formula) sun period is day of week (%u variable in date conversation formula).

I guess because you have multiple years of data in your data set the period numbers are high.

[grazitti_sapna]

@dcates , I agree with @gautiergodard may be you have dataset of various years due to which it is multiplying the value of period every year and the value is coming high after each year. Can you share the complete dataset to be more clear.

[dcates]

Sure. I have attached the dataset. This is what it is right before it goes into the ETS or ARIMA. I have another step to fill in the blanks and other cleanup. I'm passing the SaleDateFormat column for the forecasts. Thanks!