-
get month in a date
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
-
-
could u post how u solved this?
-
mm - is for minutes, MM - is for months
regard j