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.
Solved! Go to Solution.
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.
Thank you very much. This worked!!