Writing out Date from database

Hi All,

I have an ASP page that pulls a ValueDate from a SQL Server Database and write it out to my web page. The date on the SQL server looks like this DD/MM/YY(e.g 16/01/2001). However when I call this value from the database it is written out to my page in this format Tuesday Jan 16 00:00: 00 UTC 2001. Can someone please tell me why this is happening and how I can adjust this to be displayed as YY/MM/DD.

Your help is really appreciated

JK

Using the FormatDateTime function will return the data in its short (dd/mm/yy) format.

FormatDateTime(date,2)

Try that or some variation of it.