Date Select

[vlitim]

I have a list of dates in a table like this

17/12/2001
14/12/2001
15/10/2001
27/09/2001
05/09/2001
05/12/2000
05/10/2000

what I need to do is get a list like this:

december 01
october 01
sept 01
december 00

etc

anyone got any ideas!?

 

[shaddow]

U need this from querry or u can process the recordset after? ________
George, M

 

[vlitim]

I am basically getting this list from a select, so I can process it after if need be.

 

[shaddow]

This is an example:

dim monthNames(12)
monthNames(1)="Januarry"
...
monthNames(12)="December"

date="17/12/2001"

newDate=monthNames(Month(date))+" "+Right(date,2)

hope this is ans solution...
________
George, M