Hello
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
Hey Shlomo,
Skimming through the following link through the date/time section (CTR + F > Date/Time Functions) :
function.html - HXTT Text (CSV) JDBC Drivers for raw data, flat text, CSV file, TSV file, PSV file, fixed-length, and va…
I believe what you are looking for is the DATE() / CURDATE() / DATETIME() functions for your arithmetic operation here.