Month format change

[cwhittington05]

Hi all, I created a Month field in the script (Month (OrderDate) as Month;)  but I'm not sure how to format it.  Instead of showing the month number, I need it to be shown as MMM.  How and where in the script do I handle this?  TIA!!

[Frank_Hartmann]

date(Month (OrderDate),'MMM') as Month

[cwhittington05]

Thanks!  Received the following error:  Connector reply error: SQL##f - SqlState: 37000, ErrorCode: 4294964196, ErrorMsg: [Microsoft][ODBC Microsoft Access Driver] Wrong number of arguments used with function in query expression 'date(Month (OrderDate),'MMM''.

[Vegar]

The error message is an SQL / Access error.

Try to do something similar to this:

LOAD 
  Month(Date) as Month,  //This will display month as Jan, Feb, etc.
  *
;
SQL SELECT *
FROM DataSource;