Skip to main content

Hi Guys,

 

This is a question regarding New Responsive Forms for SharePoint. In the form I have start date and end date fields. Also have fields from January till December. Based on the date duration selected the number of days per month should get auto populated in respective columns from Jan till Dec. Could someone please help me with a logic to do the same?

For example, Start Date 15 Jan, End Date 25 Aug, Fields should get auto populated as below
Jan: 17, Feb: 29, Mar: 31, Apr: 30, May: 31, Jun: 30, Jul: 31, Aug: 25, Sep: 0, Oct: 0, Nov: 0, Dec: 0

Thanks
Aravind

Hi Guys,



This is a question regarding New Responsive Forms for SharePoint. In the form I have start date and end date fields. Also have fields from January till December. Based on the date duration selected the number of days per month should get auto populated in respective columns from Jan till Dec. Could someone please help me with a logic to do the same?



 



For example, Start Date 15 Jan, End Date 25 Aug, Fields should get auto populated as below



Jan: 17, Feb: 29, Mar: 31, Apr: 30, May: 31, Jun: 30, Jul: 31, Aug: 25, Sep: 0, Oct: 0, Nov: 0, Dec: 0



 



Thanks



Aravind


Reply