AnsweredAssumed Answered

hxtt - jdbc/csv date modifier

Question asked by Shlomo Katz on Apr 1, 2020
Latest reply on Apr 12, 2020 by Shlomo Katz


We import our HR file via CSV using the com.hxtt.sql.text.TextDriver and JDBC//CSV connection.

There is are two data columns called "StartDate".and "Status"

One status Pre-Start can be listed weeks in advance of the actual start date.

We do not collect on this so the account will not be created before they start.


However, now I have a need to to collect Pre-start three days before they go active.

The usual formulas for Oracle are not working.

What is the best method to make this work:

employeeStatus = 'Pre-Start' and {sysdate >= Startdate - 3} 



Thank you