date formatting

I'm having some trouble with formatting a date. I have a varible v_date that contains 9Aug99. I want it to look like this 09-Aug-1999, so here is the code I'm using. v_new_date = format(v_date, "dd-mmm-yyyy"). But what I get is this
9Aug1999. How do I correct this?

Hi,

The reason is:

The VB is NOT able to recognise it as a date.
Please use IsDate Function to exactly make sure that system recognise the date. Although you syntax is right. In case of you can user to write the date in your format then you have to write a small function which will convert your text into a standard text format.

Thanks.



Santulan