Hello everyone,
I need to create the below scenario having the difference in days created automatically in Archer:
There are two dates field- Date 1 and Date 2, based on their difference in number of days, the record needs to be created for each month via data feed until the difference in number of days are adjusted.
For example:
Date 1: 25 Jan 2019
Date 2: 7th April 2019
Difference of Days: 72 days
Expected Record creation:
1st record- Period of April - 23 days(since April has remaining days)
2nd record- Period of May - 31 days
3rd record - Period of June - 18 days (to complete 72 days (23+31+18=72))
Also, there is a limitation on number of records that can be created based on the below values. So, if the day difference between Date 1 and Date 2 is more than 30 days AND Value1 is selected, the number of record creation should be done for only 30 days starting from Date 2. Likewise, for the other 2 values.
Value1= 30 days
Value2= 180 days
Value 3= 365 days
For example:
Date 1: 25 Jan 2018
Date 2: 15 Aug 2018
Value selected: Value2 which can maximun 180 days
Difference of Days: 202 days
Expected Record creation(considering only 180 days):
1st record- Period of Aug 2018- 16 days
2nd record- September 2018-30 days
3rd record- October 2018- 31 days
4th record- November 2018- 30 days
5th record- December 2018- 31 days
6th record- January 2019- 31 days
7th record- February 2019- 11 days(completes 180 days)
Can anybody suggest the best way to calculate the remaining number of days as they are supposed to be used in another calculation for some numbers?
I hope, the explanation above is clear. If not, Please let me know .#
Thanks in advance,
Vishakha
