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!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

DATE problem

Status
Not open for further replies.

LinuxGuy

Programmer
Nov 18, 2002
37
US
my form's dates seem to only want to be accepted as
2003/12/5 i'd MUCH rather have it 5/12/2003
How can i remedy this, it say's IE format date as
2003/12/5 what can i do to Change that around?
 
Your form accepts this cuz your database want this.
You should insert date like your way (5/12/2003) but before inserting to database convert it.

myDate="5/12/2003"
tmpDate=split(myDate,"/")
myDate=tmpDate(2)&"/"&tmpDate(1)&"/"&tmpDate(0)

and so for displaying it.

________
George, M
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top