Distributing Days across Months

[rahulsingh12]

Hi,

I have two dates

start date: 01/05/2017    

EndDate: 03/06/2017

I want to distribute the number of days between the days to the months.

start date: 01/05/2017     jan   feb   mar   apr  may  jun   jul  aug sep oct   nov   dec

EndDate: 03/06/2017        0      0     0       0      31    3      0     0    0    0      0       0

How can I achieve this?

[antoniotiman]

Can You provide sample data ?

[rahulsingh12]

[antoniotiman]

See Attachment

[rahulsingh12]

what is that date that you generate ?

i guess the issue with my setup is the common date I have.

regards,

[rahulsingh12]

what if my two variables needs to a column max and min ?

regards,

Rahul

[rahulsingh12]

thanks a ton Antonio.

you are a saviour.

regards,

Rahul