I am trying to create a report in fusion to show me all the hours that have been billed between two dates. The 19th of the month. So far the query I have constructed is as follows:
SELECT SUM('Ticket Billing.Time Spent'), SUM('Ticket Billing.Time Billable') FROM 'Ticket Billing', 'Tickets', 'Users' WHERE 'Ticket Billing.Creation Date' created >= '2015-06-19' AND created <= '2015-05-19' AND 'Ticket Billing.Worker' = 'Support' GROUP BY 'Ticket Billing.Creation Date':DayName ORDER BY 'Ticket Billing.Creation Date'
This is not working and I get an error:
Expected end of query or clause, got created at offset 156
I believe it is to do with the creation date?? Any advise?