Visual Integrator Export by Date

Is it possible to subtract days from the current date?  I'm trying to do an export from the AR_InvoiceHistoryHeader table, and I want this to be automated, and I don't want to export the entire table every time.  I've tried things against the TransactionDate field like {DAY}-1 and {fn CURDATE()-1} in the Select tab, but it doesn't seem to work.  I've also tried doing similar functions as a conditional statement in the Data tab.  Does VI support this kind of date logic?