Creating an Expression from a Date Field (Help Please)

[duckster]

I one of my tables, I have a date field (DateCompleted) with the format: mm/dd/yyyy

Now, I want to create a query which would create another field (DateExpected) by using the date in the above table and adding 5 months to the date.

The only issue is that for the new field in the query I want it just to have mm/yyyy format.

For example, if the original date in the table is 04/05/2006, after running the query, I would have a new field 09/2006.

Does anyone know the exact expression I would put in the query? Thanks. The expression would be put in the "build" area.

Thanks for your help!!

 

[Jon K]

DateExpected: Format(DateAdd("m", 5, [DateCompleted]), "mm/yyyy")
.

 

[duckster]

Worked perfectly, thanks so much!