Getting the Latest status with respect to DATE entered

Hi guyz, kindly help me in this scenario:

I have a DSO and a CUBE....

DSO:

cust

status code

status date

RAW DATA

cust status code status date

payer1 1 12/31/2013

payer1 3 1/3/2014

payer2 4 12/15/2013

payer2 2 1/10/2014

CUBE:

cust

0calday

qty (KF)

RAW DATA

cust 0calday qty

payer1 1/1/2014 10

payer1 1/2/2014 20

payer1 1/3/2014 30

payer1 1/4/2014 40

payer1 1/5/2014 50

payer2 1/1/2014 60

payer2 1/2/2014 70

payer2 1/3/2014 80

payer2 1/4/2014 90

payer2 1/5/2014 100

I need to have this report: (for example I entered 1/1/2014 - 1/5/2014)

cust status code 0calday qty

payer1 1 1/1/2014 10

payer1 1 1/2/2014 20

payer1 3 1/3/2014 30

payer1 3 1/4/2014 40

payer1 3 1/5/2014 50

payer2 4 1/1/2014 60

payer2 4 1/2/2014 70

payer2 4 1/3/2014 80

payer2 4 1/4/2014 90

payer2 4 1/5/2014 100

Is this possible in query? Or do I need to do this in start routine?

By the way, I can already show the QTY figures, I used CONSTANT SELECTION..My problem now is how to the STATUS CODE..How will I do this?

Thank you!

Loed