Jorgy
-
Posts
3 -
Joined
-
Last visited
Everything posted by Jorgy
-
I found that I left out the word Month in the formula. It works when I inserted this word.
-
I tried the fomula you gave. Info as follows - Expiration Date (a date field) Three Months (calculation field)= Date((Expiration Date)-3 , Day(Expiration Date) , Year(Expiration Date) ) If I enter 9/30/2004 in Expiration Date, Three Months enters 11/30/2916 Any suggestions?
-
I am trying to create a field that automatically enter's a date 3 months prior to a field that contains a date. Example - Medication Y expires 12/30/2004, I want a field that automatically enters 9/30/2004.