date display format

[iminore]

Does anyone know what determines the format of a date (derived from a sql server database) when sent via an asp file to the browser.
It isn't the settings of the receiving pc. I know about 'set dateformat' in sql server - not relevant.

 

[onpnt]

do you mean
FormatDateTime(Date[, NamedFormat]) _________________________________________________________
for the best results to your questions: FAQ333-2924
Is your question a most FAQ?? Find out here FAQ333-3048

http://www.onpntwebdesigns.com/aspTut4.asp

 

[iminore]

no, suppose I do:

response.write(objRS.fields("datesent&quot)

I get:

2/6/2003 12:39:00 PM

Is there anyway to display it as dmy, even if I don't know it's a date field, without using any fnuctions. Is there a setting lurking somewhere ?

 

[RichS]

Not sure if I catch the end result you want("even if I don't know if it's a datefield..&quot. you might try something like in sql:

select MyDate = convert(varchar,datesent,101)
from tableName

this will cause the date to be displayed as

02/03/03

Rich