Adding Dates

Avatar

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

Avatar

Avatar

pguerett

Avatar

pguerett

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.

Avatar

Avatar

pguerett

Avatar

pguerett

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?

Avatar

19-08-2008

Could you please send me the same sample to gerardo2475@yahoo.com

Paul?

Thanks in advance.

Avatar

Avatar

pguerett

Avatar

pguerett

pguerett

20-08-2008

Just sent it