Date Filters Incorrectly Compile

[john-delivuk]

Oracles implementation uses NUMTODSINTERVAL and NUMTOYMINTERVAL to create relative dates. These methods are not implemented in netsuite's version, go figure.

Additionally fixed dates render like so

(SuiteAnalytics.salesInvoiced.trandate >= '2023-05-01T00:00-04:00[America/New_York]' )

I've been hacking away on the driver for the last 3 days trying to fix #4 and I've come to realize I am not competent in clojure. I'm happy to provide feedback or testing if needed.

EDIT:
Just wanted to add that month and quarter work correctly.

Oracle Implementation

[ericcj]

hooray welcome fellow netsuite metabase user! please let me know if you need any help getting a pull request going/tested. it looks like we could just multiply by fractions of days like the weeks version does instead of using those unsupported functions https://timdietrich.me/blog/netsuite-suiteql-dates-times/ what's the problem with fixed dates exactly?