toshog Posted December 7, 2002 Share Posted December 7, 2002 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... Link to comment Share on other sites More sharing options...
jasonwood Posted December 7, 2002 Share Posted December 7, 2002 is the field a date field? Link to comment Share on other sites More sharing options...
Vaughan Posted December 8, 2002 Share Posted December 8, 2002 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) Link to comment Share on other sites More sharing options...
toshog Posted December 9, 2002 Author Share Posted December 9, 2002 thanks Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 7944 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now