You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

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):

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!