extract date information

[Keith Crooks]

I have an access database with a field set to the current date (this
is taken from the system date how can i extract from that field just
the month and year.

or have a field that gives me only the month and year from the system
( I dont want to have to put in the month and year manually)

regards

keith

[Phil Stanton]

format(date(),"yy") gives 03
format(date(),"yyyy") gives 2003
format(date(),"mm") gives 11
format(date(),"mmm") gives Nov
format(date(),"mmmm") gives November

phil

"Keith Crooks" <ke**********@hotmail.com> wrote in message
news:ac**************************@posting.google.c om...

I have an access database with a field set to the current date (this
is taken from the system date how can i extract from that field just
the month and year.

or have a field that gives me only the month and year from the system
( I dont want to have to put in the month and year manually)

regards

keith