View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
sluff sluff is offline
external usenet poster
 
Posts: 1
Default SQL Select statement with Date as

Pepe,

Try the "To_Char" method.

TO_CHAR(UpdateDate, 'YYYY - MM')

HTH