Custom Date in Query

[frdebelo]

I have a query I am merging with Publisher and need a specific date every month. In this date, I need the day of the month to be the 9th; the current month for the current year.



Example;

We are in sept so need the date field to be September 9, 2011. Next month when I run the report, the query will populate this column with October 9, 2011, and so on.

Is there a date function i can format for this field?


Frank

[alansidman]

In an expression your query:

Current Month: Month(Date()) & " "&"9,"&" "&Year(Date())

Alan

[frdebelo]

Thank you Alan, works great.
The date is formatted in 9 9,2011,
Is there a way I can make it September 9, 2011?

Thank you for your help.

Frank

[alansidman]

Look here for formatting dates.

http://www.techonthenet.com/access/f...ate/format.php

Alan

[frdebelo]

That works, thanks again Alan.
Current Month: Format(Month(Date()) & " " & "9," & " " & Year(Date()),"mmmm/dd/yyyy")

Frank