Changing Format of Date 1

[srossbach]

I have a date field in my table that is set up to show month/date/year (11/30/01)- what I need to do is to take the month and year from that field and put it into another field that is month/year without any slashes or dashes - field must be 4 characters.

Any assistance would be appreciated.

Thanks and Happy Holidays to You!

 

[tlbroadbent]

Use the format function.

Format([date1],"mmyy&quot Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.

 

[srossbach]

Thanks - that was simple enough!

Have a great day - you made mine easier!