Add days to date

[ndjustin20]

Hello,

I'm sure this is something simple I am missing :-)

Here is the js I am using.  

var dateToNumber = Date2Num(form1.page2.page2Date.rawValue, "MM/DD/YYYY");

var datePlusDays = dateToNumber + firstRowWeek.rawValue * 7;

var boosterDate = Num2Date(datePlusDays, "MM/DD/YYYY");

form1.page2.invoiceTable.row1.boosterDate1.rawValue = boosterDate;

All I am trying to do is take a date and add some days to it depending on what someone selects from a dropdown.  The date I am using is from the

$.rawValue = num2date(Date(), "MM/DD/YYYY")

I'm not sure why I can't get this to work properly.  Any help would be much appreciated.

Justin

[ndjustin20]

bump

[radzmar · Accepted solution]

This could be done this way:

$ = Num2Date(Date2Num(form1.page2.page2Date.formattedValue, "MM/DD/YYYY") + firstRowWeek * 7, "MM/DD/YYYY")

[ndjustin20]

OMG!!!!!!!!!!!!!!!!!!!!!  I just realized Num2Date and Date2Num are Formcalc funations!!!!!!!!!!!!!  WOW!!!!!  That was dumb lol 

I'm going to need to look into formattedValue also it looks like when displaying dates/times.

THANK YOU FOR YOUR HELP!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

[radzmar]