Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

Adding Dates

Not applicable
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
6 Replies
pguerett
Level 10
Level 10
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.
Not applicable
Thanks,



nospamtradbum@gmail.com
pguerett
Level 10
Level 10
Tried sending it and your email address was not found so it couldnot be delivered. Is there a typo in the address?
Not applicable
Could you please send me the same sample to gerardo2475@yahoo.com

Paul?

Thanks in advance.
Not applicable
Thank you very much...

GG