Sorry another Date calculation

[jasoneon9]

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

[doughemi]

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

[jasoneon9]

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

[doughemi]

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

[comment]

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.

[jasoneon9]

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

[comment]

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