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.