Count number of days per month based on a start date and end date

  • 28 August 2020
  • 1 reply
  • 17 views
A

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

1 reply

A

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


View our Community Site Map

Nintex Community Sitemap
Terms & ConditionsCookie settings