07-01-2011, 02:54 AM
I have the following code:
which returns the value 6/29/2011
but I need the zero in front of the six. I need 06/29/2011 returned.
Any ideas is this is possible?
thx for looking.
Code:
eDate = DateAdd("d",-1,Now())
eDate = FormatDateTime(eDate,2)
which returns the value 6/29/2011
but I need the zero in front of the six. I need 06/29/2011 returned.
Any ideas is this is possible?
thx for looking.