Problems formating date with FormatDateTime

[Boblevien]

I am trying to format dates taken from an Access database according to the local, (ie client's), Regional Settings.

According to the documentation this ought to be achieved with:
Dim DateFormat
DateFormat = FormatDateTime (objRS("date&quot,2)

where 2 represents a short date formated according to the local settings.

It clearly works to some extent since if I use (objRS("date&quot,1) I do get a long date - but it ain't in my local (UK) format.

Any ideas?

Bob Levien

 

[dpaulson]

You could use
Dim DateFormat
DateFormat = Format (objRS("date&quot,"mm/dd/yy&quot




David Paulson

 

[dgs]

To comply with users regional config you shouldn't use a fixed format such as "mm/dd/yy". My Regional Config for Brazil is "dd-mm-yyyy".

Try this:

Dim DateFormat
DateFormat = Format (objRS("date&quot,"short date&quot

 

[Boblevien]

Hi dgs,

I tried your suggestion, which is exactly what I'm trying to achieve, and got:

Microsoft VBScript runtime (0x800A000D)
Type mismatch: '[string: "short date"]'

when I ran it. Any idea why?