I'm having a bit of trouble getting my head round date formatting in asp, my current date displays like this: 05/04/2010 21:03:14 using this code response.write("" & rs("my_date")) Does anyone know how i can format the date to show just the month, year or day. Something like this: 5th april 2010

I've dug up some code on the web that can display todays date but I can't apply this formatting to my date displayed from a database. looks like this: Response.write FormatDateTime(todaysDate,1)

use the vbShortDate constant (2)

http://www.w3schools.com/vbScript/fu...atdatetime.asp

Thanks Chris, I tried that and it shows saturday, December 30, 1899 I was wanting to make one of those date icons that some blogs have, I think I need to break the date down and display it in separate Divs. My first step is to format the output of my database, my code looks like this: response.write("" & rs("my_date")) anyone know what I should change this to, to get just the month.

Day(date())
Month(date())
Year(date())

http://www.w3schools.com/vbscript/vb..._functions.asp

Yeah this tutorial can resolve your problem.

Thanks guys, I've got it now.
All date formatting problems solved, Cheers