Date plus 14 Days

[steigrafx]

I have two date fields: one called Date Assigned, and one called Tickler. I need to populate the Ticker field with the Date Assigned plus 14 days. I thought the calculation "Date Assigned + 14" would work, but I get no results at all.

Any ideas?

Thank you,

Kevin

[Fitch]

Nothing wrong with your calculation. Make sure both Date Assigned and Tickler are Date fields.

[Cabinetman]

Do you have the calc. set to 'Date?'in the "calc. result is "

[steigrafx]

Thank you both. I just realized that when I save a record the date, in fact, does appear. But how do I "refresh" that field for all of my records without opening and saving each one separately?

Thanks,

Kevin

[comment]

It sounds like Tickler is a Date field with auto-entered calculated result. If so, change it to Calculation field (using the same formula) and set the result type to Date.

[steigrafx]

Incredible. Thanks so much for your help...again...comment.

I'll get the hang of this sooner or later.

Have a great weekend.

Kevin