karcheee
May 24th, 2005, 02:10 PM
{TLORDER.CREATED_TIME}>CURRENT TIMESTAMP-60 DAYS
I am told that A number, currency amount ... ... is expected here.
I added brackets around the second part...
{TLORDER.CREATED_TIME}>(CURRENT TIMESTAMP-60 DAYS)
I am told "the ) is missing"
I added brackets around the whole thing and im told the same thing...
This is valid SQL code!!! why doesn't crystal report allow it?
What can I write in crystal report that will accomplish the same thing as this 'Select Expert' code?
I am told that A number, currency amount ... ... is expected here.
I added brackets around the second part...
{TLORDER.CREATED_TIME}>(CURRENT TIMESTAMP-60 DAYS)
I am told "the ) is missing"
I added brackets around the whole thing and im told the same thing...
This is valid SQL code!!! why doesn't crystal report allow it?
What can I write in crystal report that will accomplish the same thing as this 'Select Expert' code?