Date Passing to other table

[zahidrahim_ocp]

Dear Experts,

I have made a qvd file with fields like:

Actual Sale

---------------------------------

TRX_DATE

SALE_VALUE

Now i want to make another qvd file with conditions on what is user selecting from above TRX_DATE

DUE_INVOICES

----------------------------------

DUE_AMOUNT

WHERE DUE_DATE < TRX_DATE (First Value from the selected dates)

AND DUE_DATE2 > TRX_DATE (Last Value from the selected dates)

What can/should be the approach?

Best Regards,

Zahid Rahim

[JustinDallas]

If it's dependent on what the user selects, then you might not really be able to make a QVD in the way you want.

[zahidrahim_ocp]

Dear Justin,

Thank you for the reply. If i dont make a QVD then what are the other options i have.

Regards,

Zahid Rahim