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

Avatar

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

Avatar

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.

Avatar

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

Avatar

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

Paul?

Thanks in advance.