Date Format Questions

[PackinDaMAC]

I have this Date varible called ydate and it shows the date like this 6/6/2006 but i need to add a zero if my dateday and datemonth are less than 10.....how would i go about do this...any help is always great!!

[SafariTECH]

That should work , so long as ydate has not been defined. What about if it IS defined?

[PackinDaMAC · Accepted solution]

I had to do this to make sure that zero was being added to the querey...its works great now...thanks