Showing Year and Month In Day Prediction

[Aashish]

Hi All 

I am trying to do a daily prediction based on Patient Data. While doing this the forecast returns the correct periods and sub periods. The problem is the Period returned is at a Week level and the Sub-Period returned is the Day Number. 

Is there a  way to show the year and Month corresponding to the predicted week and day.

For example if my Period is 105 and Sub_Period is 1 

i would need to show the output as 2018 Jan and week 1 and 2018-01-01

I have data from 2016 at a day level from 2016 through 2017 

[BenMoss]

Hi @Aashish,

It looks like the workflow was not packaged properly, and that you have used macro's that I do not have installed on my machine.

When you export the workflow as a .yxzp file make sure that you have all assets checked.

If you could please reupload I will take a look.

Ben =

[BenMoss · Accepted solution]

I managed to download and bring through the macro's myself.

Here is my solution, I have created a date field and a week field, I may not have the week field in exactly the structure you desire but now we have the date field this should be very simply to do using the datetimeformat() function (see my week formula as an example).

Hope this works.

Ben

[Aashish]

@BenMoss

This solution works 

Thanks a lot :)