Well, I had the same problem, and I solved it in the following way...

Dim strDate
strDate = Day(Date()) & "-" & Month(Date()) & "-" & Year(Date())

Then you'll get the date displayed as DD-MM-YYYY

Hope this will help



>In JavaScript is there any function which returns the format of the day in a
>DD-MM-YYYY format.
>The date function returns it in MM-DD-YYYY format but is there a format wherein i can get a DD-MM-YYYY format of the date??