AnsweredAssumed Answered

Reformatting the results of a SQL date

Question asked by Gingernut on Jan 22, 2013
Latest reply on Jan 22, 2013 by Gingernut

I have a chart which shows number of toners invoiced to a customer relating to their photocopier.

It is from the Invoice Line and I have grouped as customer will often have one of each colour on the same invoice therefore same date

I managed this more by luck than skill so any help much appreciated

 

 

The x axis is

ExecuteSQL ("SELECT

"Date"

FROM "customer_Invoice_LineItem"

WHERE "_Mach Id No" =? AND "StkDesc" LIKE '%TONER' AND qty >0

GROUP BY "date" ";

"|" ; "" ;

Machine::_ID)

 

The Y axis is

ExecuteSQL ("SELECT

count (*)

FROM "customer_Invoice_LineItem"

WHERE "_Mach Id No" =? AND "StkDesc" LIKE '%TONER'

GROUP BY "date"

";

"|" ; "" ;

Machine::_ID)

 

Works a treat but it shows the date as 2012-06-29 and I would like to show the UK date format 29/06/2012 or even better just group by Month and Year eg June 12

 

Can anyody please tell me how I need to do this

 

Many thanks

 

Cathy

Attachments

Outcomes