Smartconnect or Excel ODBC Equivalent of Getdate() = Now()

ODBC Equivalent of Getdate() = Now()

To adjust the date, use TIMESTAMPADD
https://docs.faircom.com/doc/sqlref/33476.htm

Example:

where "JrnlHdr"."TransactionDate" >= {fn TIMESTAMPADD( SQL_TSI_DAY, -2, Now())}

gets everything newer than two days ago