Format Command Problem 1

[Japskunk72]

I have a program that uses ADO to connect to SQL DB. I have a feild for date that formated like this ########. when i take it from the database i format it to ##/##/####.
my problem is when the first # = 0 it doesnt display the 0. like if the SQL data i am pulling = 09032003 then the formated result after
format(Dbrec!Date,"##/##/####&quot
the result would be
9/03/2003
is there a simple way to keep the 0 infront of the 9? so my result would be
09/03/2003?
Thanks
JT

 

[CCLINT]

Try

"00/00/0000"

 

[Japskunk72]

Thanks allot CCLint, I new it was something simple I was forgetting.
Going to be one of those days
Thanks
JT