SQL Result Set Formatting

Try something like this:

Dim strMyDate
Dim strMyFormattedDate

strMyDate = rs("myDateField")
strMyFormattedDate = Mid(strMyDate, 5, 2) & "/" & Mid(strMyDate, 7, 2) & "/" & Left(strMyDate, 4)

At this point, strMyFormattedDate should appear as "05/04/2001" for the given example you provided.

As you work for the government, should you not be setting a good example by writing all your dates in ISO format, which SQL is giving you? The format you want is a protest against the Gregorian calendar, and it is really rather late for that.

As you work for the government, should you not be setting a good example by writing all your dates in ISO format, which SQL is giving you? The format you want is a protest against the Gregorian calendar, and it is really rather late for that.

If SQL's result is known to be a date, then I would have thought...

Public Function ChangeDate (dteOldDate as date) as Date
ChangeDate = format("dd/mm/yyyy")
End Function

...would have worked.

try:

declare @d varchar(8)
set @d = '20010504'
select convert(char(10),cast(@d as datetime),101)

This question was closed by the author