format date obj with leading Zeroe ??? 1

[Dylan]

I have a date fld that I need help in converting into a string using leading zeroes for month and day as needed.

depdte(date/time) has date value of 9/1/2004

tried this but didnt work

wsdte = Format(DatePart("m", Irs.Fields("depdte"), "00"))

This returns: 9

I need it to return: 09

Thanks for any help on this ...

Tom Moran
Lansing, Michigan

 

[KenReay]

Hi

Format(depdte,"dd/mm/yyyy")

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[SkipVought]

Tom Moran,

This give you TEXT -- NOT a DATE!
[tt]
x = format(DatePart, "mm/dd/yyyy")
[/tt]
or just to return month...
[tt]
x = format(DatePart, "mm")
[/tt]


Skip,

_{[red]Be advised:[/red] It's been reported that a wee psychic is roaming the countryside.
Small Medium @ Large!}

 

[Dylan]

skip,

where should depdte be included in code ???

Tom Moran
Lansing, Michigan

 

[SkipVought]

sorry
[tt]
txtDateString = format(depdte, "mm/dd/yyyy")
txtMonthString = format(depdte, "mm")
[/tt]


Skip,

_{[red]Be advised:[/red] It's been reported that a wee psychic is roaming the countryside.
Small Medium @ Large!}

 

[Dylan]

THANKS Skip


works like a charm ....

Tom Moran
Lansing, Michigan