December 7, 200223 yr i'm having a little trouble with dates... trying to do a little script that takes a date from one field and then adds 365 (days) to that date and puts it in another field - it seams the calculation is working but the formating isn't.. (format date doesn't do it)... help...
December 8, 200223 yr If you want to add one year to a date, don't do it by adding 365 days because 365 days isn't one year. (And don't try adding 365.25 days either... yuk.) Do it properly, with this calculation: Date(Month(startdate), Day(startdate), Year(startdate) + 1)
Create an account or sign in to comment