Format date from ACCESS database

[ELVIS]

I'm a 'newbie' with a quick question:

I have an ACCESS database and am using a SQL statement to retrieve data.

sql = "SELECT * FROM users WHERE surname Like '" & startletter & "%' ORDER BY lastname"

I now have a table that has the following asp code:

<%=rsUsers("date")%>

This returns a date which reads something like this:

1/10/2007 12:58:36 PM

How do I get it to show the date only? i.e., 1/10/2007 ?

Thanks

 

[ChrisHirst]

FormatDateTime

Chris.

Indifference will be the downfall of mankind, but who cares?
Woo Hoo! the cobblers kids get new shoes.
People Counting Systems

So long, and thanks for all the fish.

 

[ELVIS]

Thanks, but how do I integrate the two codes?

I have the ACCESS data: <%=rsUsers("date")%>

How do I use the script:
document.write(FormatDateTime(Date(),2))

 

[gmmastros]

document.write(FormatDateTime([!]rsUsers("date")[/!], 2))

-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom

 

[ELVIS]

Hmmmn...

Doesn't work!

 

[ChrisHirst]

response.write formatdatetime(date,format)



Chris.

Indifference will be the downfall of mankind, but who cares?
Woo Hoo! the cobblers kids get new shoes.
People Counting Systems

So long, and thanks for all the fish.

 

[monksnake]

Hmmmn...

Doesn't work!

What doesn't work about it? If it gives an error, what error?

<.

 

[ELVIS]

Thanx!!!

 

[bslintx]

since using access...a built-in may work for you(i imagine based on what version)...very nice to have since you can use the formats in access or customize your own..ie -

sql = "SELECT Format(date,""short date"") AS FormatedDate FROM users;"

'1/10/2007 

sql = "SELECT Format(date,""m.d.yy"") AS FormatedDate FROM users;"

'1.10.07

sql = "SELECT Format(date,""dd-mm-yyyy"") AS FormatedDate FROM users;"

'10-01-2007