Date help: extracting mm/yy out of dd/mm/yy format

[tangcla]

Hi,
I'm looking for help on how to structure an argument in a query to extract just the month and year out of a date field.

i.e. I want to take dd/mm/yy only.

Any help would be appreciated

 

[boblarson]

One way:

NewFieldName:Format([YourDateFieldNameHere],"mm/yy")

which then is a string field.

 

[tangcla]

Thanks Bob, it worked

I tried that one earlier, but for some reason it didn't seem to like it. Not sure why, but oh well.