Highlighted

Adding Dates

Avatar

Guest

12-08-2008

Is there a way to add calculated dates in a Date/Time field based on an entry in another?



I.E. dtGoodThrough = dtRequestedDate+(7*13)



In essence adding 13 weeks to an initial date selection?



Thanks,



Smitty

Replies

Highlighted

pguerett

12-08-2008

Yes ...you have to convert the date to a number (# of milliseconds from the epoch) and then add the allotted number of milliseconds then convert back.



If you post your email address I will send you a sample that adds 1 year to the date.
Highlighted

pguerett

13-08-2008

Tried sending it and your email address was not found so it couldnot be delivered. Is there a typo in the address?