Division by zero (on a date)

[David Laplante]

I have a small problem. I have a division by zero error when using the following date value: 22/06/00 (which is today's date). My division by zero error occurs because of the trailing /00.

I went in the regional setting and used "-" as date seperator and now it works perfectly. Since it's an application I will use on many computers, I would like it to work without having to play with the regional settings. (same thing if I would put the year of 4 digits)

I tried using cdate() and format([date],"Short date") on my value but it won't work. Is there a way of getting around this?

Thanks.

[Iain17]

dim stDate as String

stDate = Format(now, "dd-mm-yy")

[David Laplante]

Now that's quick for an answer.

love this place..

Thanks.