Joined
Last Seen
0 Reputation Points
Unknown Quality Score
No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.
0 Endorsements
Ranked #107.40K
[code]<cfquery name="findQtrs" dbtype="query"> SELECT DISTINCT DATEADD(qq, DATEDIFF(qq, 0, event_datestart), 0) as SQtr, DATEADD(qq, DATEDIFF(qq, -1, event_datestart), -1)as EQtr FROM eventData ORDER BY SQtr ASC </cfquery>[/code] when I run the above I get error in syntax of '(' looking for a from. However, when I run that exact query in SQL … |