Modifying date information

[JMLU]

I have a date field [Contract End Date] that has the date entered in mm/dd/yy
format. I would like to run a query that shows the 1/1/09 thru 3/31/09 data
as "Q109" and so on through the year. What is the best way to set this query
up?

 

[John W. Vinson]

I have a date field [Contract End Date] that has the date entered in mm/dd/yy
format. I would like to run a query that shows the 1/1/09 thru 3/31/09 data
as "Q109" and so on through the year. What is the best way to set this query
up?

Just include the date field in the query, and set its Format property to

"\Qqyy"

or use that format string as the Format property of a form or report textbox.

The \Q means to include a literal letter q in the string; the q format value
returns the quarter; and the yy the last two digits of the year. This doesn't
affect the stored date, just how it's displayed.