Hi all

I have an automatic date field set up in one of my tables. What I need to do is extract just the Month and the Year from this field in a query or within the table itself. Is this possible to do? If so, how?

Any help most appreciated!

--------------------------------------------------------------------------
Starlight :)

Format(date(),"MMM-YYYY")

Sep-2003

Check out format in the help for more info

Check datepart as well while you are at it

Regards

The Mailman