Hello folks

Im using SQL 2000 & ASP

I need to display the date from my SQL DateTime field in the following format;

'August 2005'

The closest I can get to this is;

'24 August 2005'

Can anyone help or point me in the right direction please ?

Many thanks

Donald

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...

Check on the Month, Year, MonthName functions and you should be able to solve this problem easily.

Hi,
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