I'm trying to limit my data in QS by a date expression in the data load editor.
I would like to limit the data so that it only shows invoices that are past due date today (current date).
The field that set the due date is called: [SupplierInvoiceDueDate]
Add a where clause like this:
Where Num(SupplierInvoiceDueDate) <= Num(Today());
Thank you, it worked out really well.
may be this?
Retrieving data ...