Calculating Forecast Length via Dates
Posted: Fri Nov 10, 2017 8:47 am
Hi again
I am using:
%history_end_date="2017.09"
%forecast_start_date="2017.10"
%forecast_end_date="2019.12"
To start and label workfiles. I need to be able to get the number of months between %forecast_start_date and %forecast_end_date
I don't think datediff can work due to them being characters. Is there a way around this? Again I need number of months between them, in this case it is 27
thanks
I am using:
%history_end_date="2017.09"
%forecast_start_date="2017.10"
%forecast_end_date="2019.12"
To start and label workfiles. I need to be able to get the number of months between %forecast_start_date and %forecast_end_date
I don't think datediff can work due to them being characters. Is there a way around this? Again I need number of months between them, in this case it is 27
thanks