Month/Year Format

[Beverly]

I created an invoices database with one field being "Month Paid" but I can't
seem to get the formatted date the way I want. I want MON-YY. So, Jan-05,
Feb-05, Mar-05 but there doesn't seem to be a date format with that
selection. So, I made the fields text fields and just typed in the Month &
Year but now when I want to create a report and group by the Month & Year
field, it sorts them alphabetically, obviously b/c it's text. I want it to
obviously be Jan, Feb, Mar, etc.

Can someone help?

Thanks.

 

[Guest]

Hi Beverly

Format the "date" field - not text - as MMM-DD

 

[Beverly]

I guess I don't know how to do that. When I'm in design mode on the table,
do I choose Date/Time for the Data Type? If so, my choices for Format down
below under General don't seem to include MMM-YY.

Thanks.

 

[fredg]

I guess I don't know how to do that. When I'm in design mode on the table,
do I choose Date/Time for the Data Type? If so, my choices for Format down
below under General don't seem to include MMM-YY.

Thanks.

You are not limited to the formats in the format property dropdown.

The field should be a date/time field.
You must store a valid date (Month/Day/Year, i.e. 5/3/2006).
Write
mmm-yy
on the Format property line.

A date such as 5/3/2003 will display as May-06