Thank you Joel. It's QoQ issue. I can't use Datediff in QoQ :(
On 08/06/06, Joel Cass <[EMAIL PROTECTED]> wrote:
Is this too advanced for CF's ailing query of queries? I do not use this feature much so am unsure
You could try
SELECT (date_com-date_submitted) AS SubTotalNum
Though I cann
Is
this too advanced for CF's ailing query of queries? I do not use this feature
much so am unsure
You
could try
SELECT (date_com-date_submitted) AS
SubTotalNum
Though I cannot guarantee that it works as I
used to subtract dates this way a long long time ago.. before I knew that
da
hashes are your friendOn 6/8/06, George <[EMAIL PROTECTED]> wrote:
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