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

That should work fine as you wrote it.  Did you make the calculation result Date in Field 3?

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

Also un-check the "Do not change existing value of field" box.

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.

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

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