var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: ASP DateTime Format Problem
Im using SQL 2000 & ASP
I need to display the date from my SQL DateTime field in the following format;
The closest I can get to this is;
'24 August 2005'
Can anyone help or point me in the right direction please ?
There are a few ways.... the most obvious to me would be something like
not sure if this will give you August 2005 or August 05 though...
datDate = CDate(recordsetName("FieldName"))
strDate = MonthName(Month(datDate)) & ' ' & Year(datDate)
Check on the Month, Year, MonthName functions and you should be able to solve this problem easily.
Last edited by rokslide; 10-24-05 at 22:16.
Reason: missed the closing code tag
For that you might need to use the MonthName() and Year().
MonthName(datDate) will print full month name. i.e. August
MonthName(datDate, True) will print month name in abbreviated form. i.e. Aug