Hi,
I try to use datediff() function in SQl select statement but got an error:
Error Executing Database Query. | |
Query Of Queries syntax error. Encountered "(. Incorrect Select Statement, Expecting a 'FROM', but encountered '(' instead, A select statement should have a 'FROM' construct. | |
The error occurred in E:\webroot\IntraDev\ISTUHelpDesk\Administration\isuadmin.cfc: line 227 Called from E:\webroot\IntraDev\ISTUHelpDesk\Administration\isuSupportStats.cfm: line 9 Called from E:\webroot\IntraDev\ISTUHelpDesk\Administration\isuSupportStats.cfm: line 1 Called from E:\webroot\IntraDev\ISTUHelpDesk\Administration\isuadmin.cfc: line 227 Called from E:\webroot\IntraDev\ISTUHelpDesk\Administration\isuSupportStats.cfm: line 9 Called from E:\webroot\IntraDev\ISTUHelpDesk\Administration\isuSupportStats.cfm: line 1 | |
225 : SELECT abs(datediff(dd,date_submitted,date_com)) AS SubTotalNum 226 : FROM qAllRequestedJobsWithAllFields 227 : WHERE (date_submitted BETWEEN #convertedStartDate# AND #convertedEndDate#) AND (date_com is not null) 228 : </CFQUERY> 229 : </CFCASE> Could anyone please help? Thanks, George |
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "cfaussie" group.
To post to this group, send email to cfaussie@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at http://groups.google.com/group/cfaussie
-~----------~----~----~----~------~----~------~--~---