get month in a date

[fmardani]

Hi,
My datareader returns a date as follows:

oDrIdentifier.Item("WorkOutDate")
return: #11/14/2011#

I would like to separate year, month, and day.
in immidiate window running:

?format(oDrIdentifier.Item("WorkOutDate"),"yyyy")
returns : "2011"

?format(oDrIdentifier.Item("WorkOutDate"),"dd")
returns: "14"

?????BUT????
?format(oDrIdentifier.Item("WorkOutDate"),"mm")
returns "00"
whereas it should return 11

Any ideas please?
THanks

[fmardani]

solved. thanks

[Andy]

could u post how u solved this?

[janis]

mm - is for minutes, MM - is for months

regard j