Error with Next 90 Day Syntax
Summary:
I'm getting an error when I use the below formula to get the next 90 days form a specific date field in my filter.
Content (required):
The error I'm getting below is as follows:
Formula syntax is invalid.
[nQSError: 10058] A general error has occurred. (HY000)
[nQSError: 43113] Message returned from OBIS. (HY000)
[nQSError: 27002] Near <>=>: Syntax error (HY000)
[nQSError: 26012] . (HY000)
SQL Issued: SELECT "Worker"."Employee Hire Date" >= TIMESTAMPADD(SQL_TSI_DAY, +90, CURRENT_DATE) FROM "Workforce Management - Worker Assignment Event Real Time"
OK (Ignore Error)
Any help with solving this is much appreciated.
Version (include the version you are using, if applicable):