Getting January to show as Default

[Carly]

I have got a textbox on a form & I would like the default value to be the year (2003) & then January (01) (i.e. 200301).

I can get the year by using the first part of the following formula but I am unsure what to put after the & to get 01

=Year(Date()) & -------

Any Ideas?

Regards
Carly

 

[Mile-O]

=Format(DateSerial(Year(Date()),1,1), "yyyy mm")

 

[Carly]

This gives me 20031 but I need 200301

Is there anyway this can be done?

 

[Carly]

I tell a lie, it works Thanks!!

 

[Mile-O]

Are you sure? It works fine for me.

 

[Mile-O]

No probs.