Displaying date format

[gbert]

Hello all,

I am trying to output a date/time value using the following: #DateFormat(dt, "mm/dd/yyyy")#
The date is entered into the variable 'dt' in the following format: "Mon, 08 Nov 2004 22:33:37 +0000"
However, I ran into an odd problem, this seems to work well for Mon, Fri, Sat, Sun but when the date is one of 'Tue, Wed, Thu' (ie. 'Tue, 19 Oct 2004 19:15:22 +0000' ), I get this error message:

The value "Tue, 19 Oct 2004 19:15:22 +0000" could not be converted to a date.

Any idea why this is happening only for specific days of the week?

Thanks for any assistance.
Gord.

[dempster]

I ran into this problem last year and found that UTC dates with Tue, Wed or Thu as days of the week will cause errors. The answer was to use the ParseDateTime() function.

Here's the thread.

-Paul

[gbert]

Thanks Paul,

That thread addresses my issue exactly as I was trying to parse dates from an RSS feed as well.

Cheers,
Gord.