Date Time Problem

[karlmcauley]

I have records returned from a sql query and displayed in a table. There is a date/time field amongst this information. I am in Northern Ireland but the date is americanised. what format date time function can i use to get it dd/mm/yyyy instead of mm//dd/yyyy?

Any help would be appreciated.

Cheers

I actually got help with solving it:


StrDate = rsTemp("ILRDateRun")
strDateTime = mid(strDate,4,1)+"/"+mid(strDate,1,2)+"/"+mid(strDate,6,4)

And then i used strDateTime to return the results from the database.

[lillu]

See this post:

http://forums.webdeveloper.com/showthread.php?s=&threadid=18943

[simflex]

I believe that this will give you the format you want.

StrDate = rsTemp("ILRDateRun")
<%= FormatDateTime(StrDate, 2)%>