jasoneon9 Posted May 9, 2014 Share Posted May 9, 2014 Hi sorry ive read lots of date calculations but just cant seem to find the answer im looking for i almost think this should be fairly easy but im just not grasping it Please help OK i have created 3 fields Field 1, Record created (auto entered) Field 2, Days (entered manually) Field 3, New_Date (record created + how many days entered to give a new calendar date) Many thanks in advance Link to comment Share on other sites More sharing options...
doughemi Posted May 9, 2014 Share Posted May 9, 2014 That should work fine as you wrote it. Did you make the calculation result Date in Field 3? Link to comment Share on other sites More sharing options...
jasoneon9 Posted May 9, 2014 Author Share Posted May 9, 2014 thanx for helping i have tried it set to date and calculation am currently set to date i have ticked calculated value in the auto-enter and specified RecordCreated + Days i guess im missing somthing Link to comment Share on other sites More sharing options...
doughemi Posted May 9, 2014 Share Posted May 9, 2014 Also un-check the "Do not change existing value of field" box. Link to comment Share on other sites More sharing options...
comment Posted May 9, 2014 Share Posted May 9, 2014 am currently set to date i have ticked calculated value in the auto-enter and specified RecordCreated + Days You should change the field's type to Calculation, using the same formula. Make sure that the calculation's result type is set to Date and that RecordCreated is a Date field and Days is a Number field. Link to comment Share on other sites More sharing options...
jasoneon9 Posted May 9, 2014 Author Share Posted May 9, 2014 great thanx all its working tried all your suggestions sure it helped but was still not working it seems i had the record created field set to timestamp instead of date really appreciated all your help Link to comment Share on other sites More sharing options...
comment Posted May 9, 2014 Share Posted May 9, 2014 tried all your suggestions sure it helped but was still not working All your suggestions? Make sure that ... RecordCreated is a Date field BTW, if you prefer, you can leave RecordCreated as Timestamp field and change your calculation to = GetAsDate ( RecordCreated ) + Days Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 3639 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