Parsing date field 1

[SidLancing]

I have a date field named OrderDate in a form. I have this vba code to get the just the year.

Cur_YR = DatePart("yyyy", [OrderDate])

In the table the field is defined as a Date/Time Datatype and the default value is =Date()
Can anyone help with getting the year to be 04 instead of 2004


Thanks in advance.

 

[RoyVidar]

Something like this?

[tt]Cur_YR = right$(DatePart("yyyy", [OrderDate]),2)[/tt]

Roy-Vidar

 

[SidLancing]

Thanks for the tip Roy.

 

[PHV]

And what about this ?
Cur_YR = Format([OrderDate], "yy")

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244