Date Format Question

[TR21Mark]

I have several unbound textboxes on a form. They have date calculations in the control source of the textboxes. I have them set to 'Short Date' format.

This is the calculation I have in the textbox.

=DateSerial(Year([DateCode]), Month([DateCode])+1, Day([DateCode]))
(Please note that they each increment under Month +2,+3,+4 etc)

What I would like displayed in the textbox is this 'Apr-09', but what I have is 4/1/2009 because it is set to Short Date.

I went into properties of the controls and entered "mmm-yy" and when I opened the form the only thing that was showing is the actual mmm-yy letters.

Do I need to create a custom date format, or do I nest the Format function in the above calculation ( which I am not sure how to do)

Any help is much appreciated.

Thanks

 

[TR21Mark]

Disregard post


I was quotations in the format section under properties "mmm-yy"

I typed mmm-yy without quotations and it works perfectly like I need it too.

Thanks