Help with date expression

[Anonymous]

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

[sunny_talwar]

Add a where clause like this:

Where Num(SupplierInvoiceDueDate) <= Num(Today());

[Anonymous]

may be this?

Load

*

from Table

where Date(InvoiceDateField,'DD/MMM/YYYY')<=Date(Today(),'DD/MMM/YYYY')

[Anonymous]

Thank you, it worked out really well.