Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I would like to do some ageing 30, 60, 90+.
I created a script with a where clause which looked similar to the following:
LOAD fields
SQL SELECT fields
FROM
John,
You're makinga a typical mistake trying to use QV functions (in this case addmonths and today) in SQL SELECT. You can use QV functions only in LOAD. For example:
LOAD
...
WHERE Date>=addmonths(today(), -1) and Date<=today();
SQL SELCT
...
FROM;
John,
You're makinga a typical mistake trying to use QV functions (in this case addmonths and today) in SQL SELECT. You can use QV functions only in LOAD. For example:
LOAD
...
WHERE Date>=addmonths(today(), -1) and Date<=today();
SQL SELCT
...
FROM;
Thanks mate, works