hi

i stored some dates in ms acces, and i'm using visual studio 6.0, visual basic 6.0

i used this sql statement to get the monthnumber out of the dates, stored as short date type.

month([cd.datum]) as maand.

this works

now i want to get the monthname out of the monthnumber
and i tried this

MonthName(month([cd.datum]),true) as maandnaam

Probably i'll get a syntax error too, but now i only get the following message

'expression contains an undefined function MonthName'

According to msdn.com,this function should be defined in vb 6.0 !


Do i have to update my visualstudio ?
where can i find those updates?
is my syntax right? (i want the monthname, abreviated = true)

thx
grtz,
w.