Date of Last Visit Problem

[#1]

Hi Guys,

I'm trying to compute the Date of Last Visit column. Currently my data contains Userid and Date columns and I have calculate the Date of Last Visit. To do this I have to look at each user and find the last Date of Visit. In User1 for Date 1/30 his last visit date is 1/26. Similarly User1 for Date 1/26 his last visit date is 1/25. For User1 and 1/24 he won't have last visit date because we don't that historical record. Is this doable in QV? Not sure how to do this lookup.

Please advise.

Thanks for your time.

V.