asp date formatting

[sweetleaf]

Hi there!

How do i print the following recordset Date to screen in Long format(mm/dd/yyyy) rather than short format:

<% Response.Write (rst(&quot;CYCLE_APPL_START_DAY&quot & &quot;</BR>&quot%>

The machine that the web server is on has its regional settings set to short date (m/d/yy) and i hav no control over the server settings.

any help is GREATLY appreciated!

 

[Mighty]

sweetleaf,

Just use the following:

formatDateTime(rst(&quot;CYCLE_APPL_START_DAY&quot, 1)

The &quot;1&quot; signifies long date format. Mise Le Meas,

Mighty

 

[sweetleaf]

hey Mighty!

Thanks bud but I've tried that already and I got
&quot;Thursday October 15, 2001&quot; rather than simply &quot;10/15/2001&quot;
I think i may just alter my sql in the com object rather than deal with DATE-FORMATTING on the actual ASP.

cheers

 

[link9]

formatDateTime(rst(&quot;CYCLE_APPL_START_DAY&quot, 2)

is what you're looking for -- vbShortDate is the constant enum (if you have included your adovbs.inc file)


Paul Prewett

 

[Mighty]

sweetleaf,

If you want to display the date in the mm/dd/yyyy format then you can just do the following:

' Make sure it's in date format
myDate = formatDateTime(rst(&quot;CYCLE_APPL_START_DAY&quot)

myLongDate = month(myDate) & &quot;/&quot; & day(myDate) & &quot;/&quot; & year(mydate)

response.write myLongDate
Mise Le Meas,

Mighty