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?
289
370