John, as usual you are THE man! If you don't mind I have one more question
regarding this, I am trying to compare MyDate to Date() to see if 6 months
have lapsed, if so then ...do whatever
Probably the format is NOT what I need, Guess should be DatePart???
.... If Format(MyDate, "m") >= Format(Date, "m") Then
In plain English: if OriginalDate + 6 months => The current Date then run
code...
The Day it's not important only the year and the month are.
e.g. something was done on January 13, 2009 the next time should be done any
time in July 2009 or later.
John Spencer (MVP) said:
That should work if MyDate is a datetime field in your table. You do have an
extra set of parentheses in what you posted and they are not in the correct
positions
Field: TheMonth: Format(DateAdd("m",6,[MyDate]),"mmm")
If you maintained what you had, you would need to move ,"mmm") so your
expression would look like:
=Format((DateAdd("m",6,[MyDate])),"mmm")
John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
I am trying to Add 6 months to [MyDate] field and format the result in Month
only
I know that Format([MyDate],"mmm") will show only the month
and
DateAdd("m",6,[MyDate]) will add 6 months to MyDate
But how I can not get both syntax work together?
This is what I have done but it does not work :-(
=Format((DateAdd("m",6,[MyDate]),"mmm"))
Thanks for the help folks.