Add one day (date) to each row instance

Avatar

Avatar

walkerb3

Avatar

walkerb3

walkerb3

04-01-2021

I'm trying to do the following with formCalc, but javascript will do as well.  I have a travel expense form with a travel start and end date field.  The difference in days sets the instances of an expense table. I'm trying to get the first row = to the start date; for each subsequent row, I'm trying to add a day to each row.  I've declared a variable to formate the date to a number (var startDate2Num = Date2Num(sf_Header.tbl_Header.Row3.dtd_Start,"YYYY-MM-DD")).  That works; however, I cannot add 1 to each subsequent instance. 

FormCalc javascript

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar

shelly-goel

MVP

Avatar

shelly-goel

MVP

shelly-goel
MVP

04-01-2021

@walkerb3 

You can try this: Num2Date(Date2Num(sf_Header.tbl_Header.Row3.dtd_Start,"YYYY-MM-DD") + 1)

And a similar example available here:

https://experienceleaguecommunities.adobe.com/t5/adobe-livecycle-questions/adding-days-to-a-date/qaq...

Answers (0)