Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello!
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]
/ Madeleine
Add a where clause like this:
Where Num(SupplierInvoiceDueDate) <= Num(Today());
may be this?
Load
*
from Table
where Date(InvoiceDateField,'DD/MMM/YYYY')<=Date(Today(),'DD/MMM/YYYY')
Thank you, it worked out really well.