Simple Date Convert from Week ending Date to Year and Month for TS predictions

Question

Hello,

I'm simply trying to convert a week ending date of '2016-01-10' to '2016-01'

For some reason, I cannot get this to work. I want to convert week ending date to year and month for Time Series projections.

I'm using the ARIMA TS model -  I think I need to convert my week ending date to yyyy-mm, and then it will work.

Any help I appreciate.

garthheward · Accepted Answer

Assuming you have your date in column called [date] and it is in a date format, you can do this in a formula:

DateTimeFormat([date],"%Y-%m")

This will format the date element into a string of format yyyy-mm

Alternatively, if you input is a string then you can left([date], 7) to get the result since it looks like your months are padded to two digits.