datepart function

[iccsi]

I want to use datepart function to get date part always 2 digits like
following

DatePart("d", MyDate)

If MyDate is Jan/1/2011 then "01" but the function return "1"
Same as the month, I need get DatePart("m", MyDate) to return "01",
but not one.

I just wanted to know any option can do this or I need create my
function for this?

Your help is great appreciated,

 

[John W. Vinson]

Use the function Format for this:
Format(DatePart("d", MyDate),"00")

Peter
http://access.xps350.com

or more simply,

Format([MyDate], "dd")
--

John W. Vinson [MVP]
Microsoft's replacements for these newsgroups:
http://social.msdn.microsoft.com/Forums/en-US/accessdev/
http://social.answers.microsoft.com/Forums/en-US/addbuz/
and see also http://www.utteraccess.com

 

[Mike Painter]

I want to use datepart function to get date part always 2 digits like
following

DatePart("d", MyDate)

If MyDate is Jan/1/2011 then "01" but the function return "1"
Same as the month, I need get DatePart("m", MyDate) to return "01",
but not one.

Others have shown a couple methods but it is important for you to realize
that datepart returns a number.
Numbers are always 1,2,3,4 etc. and formatting is the only way to geet
leading zeros.

 

[iccsi]

Others have shown a couple methods but it is important for you to realize
that datepart returns a number.
Numbers are always 1,2,3,4 etc. and formatting is the only way to geet
leading zeros.

Thanks a millions for helping,