Date format

Maki9 · Nov 17, 2003

I'm trying to format date to dd/mm/yyyy but i'm failing..
Sql server view dates as dd/mm/yyyy but when i display the dates from the database they appear as mm/dd/yyyy so is you have the answer please reply... everytime i pass a parameter i always get an error..

shaddow · Nov 18, 2003

You can use this way. Should work in any case.

Code:

myDate=rsSql(&quot;mydate&quot;)
myNewDate=Day(myDate)&&quot;/&quot;&Month(myDate)&&quot;/&quot;&Year(myDate)

________
George, M

GaryC123 · Nov 18, 2003

Or for future development, use the standard format yyyy/mm/dd.

Year(myDate) & "/" & Month(myDate) & "/" & Day(myDate)

http://www.intouchmedialtd.com

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Date format

Maki9

Programmer

shaddow

Programmer

GaryC123

Programmer

Similar threads

Part and Inventory Search

Sponsor