1. We have moved from vBulletin to XenForo and you are viewing the site in the middle of the move. Though the functional aspect of everything is working fine, we are still working on other changes including the new design on Xenforo.
    Dismiss Notice

Help me out in this query

Discussion in 'Meet and Greet' started by Tulasi Vemuri, Apr 27, 2012.

  1. Tulasi Vemuri

    Tulasi Vemuri New Member

    Joined:
    Apr 27, 2012
    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    0
    Hi,
    I want a details like, take a person id, his billng details available in abc table. he may not be pay bill every month. he can pay with 3 months gap or 4months gap etc..or continusly.
    my condition is I want a list of person ids with his last payment bill date and previous bill date should be greater than 90days.

    I have taken aggregation function like maximum date(last bill date) and second maximum(previous bill date)those bill payment dates of that person id, but how to choose those days should be greater than 90days.
    is there any function like add 90 days to a field???

    Thanks for understanding!!



    Tulasi
     

Share This Page