Type Mismatch when formatting dates

[Molema]

I am trying to format the current date i.e. Date() or Now() with various date functions, but I continuously get a 'Type Mismatch' error.
I cannot see any fault with the syntax i am using i.e. FormatdateTime(Date(),1)
Could someone please shed some light on this for me ??

 

[jmerencilla]

try this:

FormatDateTime(Now(), 1)

inform me if this works.

 

[Molema]

I have just changed my regional settings back to English(United States), which seemed to solve the problem.
Thanks Anyway

 

[Tarwn]

There have been many problems reported with DateTime objects with certain regional settings, if you do a search you should get quote a few hits on that, in fact just doing a search on FormatDateTime will probably give you a bunch
-Tarwn ------------ My Little Dictionary ---------
Reverse Engineering - The expensive solution to not paying for proper documentation