Date Format

[David Patterson]

Does anyone know how I can format a Date/Time field to display dates in the
format Jan-2005, Feb-2005 (preferably with a space between month and year
instead of a hyphen) and so on? I have tried using a Medium Date format and
then formatting the Input Mask as LLL-0000 which works fine for input but
when I move to the next field the date reformats as 01-Jan-2005 etc. If I
can do it will the same formatting work in queries, forms or reports?

Thanks,

David

 

[Rick Brandt]

Does anyone know how I can format a Date/Time field to display dates
in the format Jan-2005, Feb-2005 (preferably with a space between
month and year instead of a hyphen) and so on? I have tried using a
Medium Date format and then formatting the Input Mask as LLL-0000
which works fine for input but when I move to the next field the date
reformats as 01-Jan-2005 etc. If I can do it will the same
formatting work in queries, forms or reports?
Thanks,

David

Use a format property of "mm yyyy". You are not restricted to the "Named"
formats.

 

[David Patterson]

Rick,

That's great. I didn't realise that. Thanks very much.

David.