DateAdd issues for a Newbie

[klacuna]

Hello All!

Newbie here!

I have a very simple database and I am trying to track deadlines. I have a meeting date and I need to calculate 90 days out in the critical date field. I used the following in the critical date field:

=DateAdd("d",90,[MeetingDate])

However nothing is calculated on the form. I have used this before and it worked just fine. I thought my database was corrupted so I deleted it and started over. I re-typed from scratch all my records. Fortunately only 46 of them.

I have read everything I can find and if the answer is out there, I missed it.



What am I doing wrong?? Thanks for any and all help!

[JoeM]

How about doing the calculation in a Query, and then base your Form on the Query (instead of the Table directly, if that is what you are doing now)?

[klacuna]

Thanks for the quick response, unfortunately that did not work either.

[JoeM]

How is it not working?
What does the calculated field in your query return?
What is the data type of the "MeetingDate" field?
Can you post some example of what the data is in "MeetingDate" that do not work?

[Bulzie]

Where did you put =DateAdd("d",90,[MeetingDate])? Is that in the Control Source box for field CriticalDate on your Form? I did quick test and it seems to work ok.

[klacuna]

Thank you Bulzie!

I was having one of probably many blonde moments today. I was putting my formula in the wrong place! Thank you!!!