record for single date

[#1]

Hi Experts,

I have sales records for april month in a qvd.

I want to pick up the sales data for a single date.

for example, the qvd has date field starting from 01/04/2015 to 24/04/2015. Now i have to pick up sales records only for 22/04/2015.

How can i do that.

I have tried using match(), wildmatch(). but its not working.

Please give some suggestions.

[Anonymous]

Speaking of "drop" - it makes sense to drop table right after "store".  First, it is removed from memory sooner, and second - no need for noconcatenate.

Small things but helpful when there data is large.