Datepart alternative

[BigDelGooner]

Hi all

I am sure there is a simple answer, as always, but I just cant figure it out.

I would like to return just the days of a date so for example today (03/10/2011 or 10/03/2011 for those of you in the US)...when I use the Datepart function below

Day = DatePart("D", Date)

It returns 3...however this is where my problem is. I would like it to return 03. Is there a simple alternative?

Thanks in advance

 

[VoG]

You can but it will return a string

aDay = Format(DatePart("D", Date), "00")

 

[Rick Rothstein]

Try it like this...

TheDay = Format(Date, "dd")

I did not use Day as the receiving variable name because Day is the name of a built-in VB function.

 

[BigDelGooner]

Thank you for the response guys, very much appreciated!