Add one day (date) to each row instance | Community
Skip to main content
January 4, 2021
Solved

Add one day (date) to each row instance

  • January 4, 2021
  • 1 reply
  • 1093 views

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. 

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by shelly-goel

@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-p/151564

1 reply

shelly-goel
Adobe Employee
shelly-goelAdobe EmployeeAccepted solution
Adobe Employee
January 5, 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-p/151564