1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Is it possible to derive a recurring date based upon a single date?

Discussion in 'SQL PL/SQL' started by ethelena8x, Apr 8, 2018.

  1. ethelena8x

    ethelena8x Newly Initiated

    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    30
    Location:
    Ha Noi
    I'm trying to set up a reminder. It needs to remind users of a reassessment date that occurs every 90 days based upon the first contact (enrollment_date) with a potential client. But I only need to show the closest upcoming date. So if a client's next closest assessment date is 12-12-15 it would show that date until 12-13-15 when it would be begin to show 3-11-16. Is that possible?
    Thanks
     
  2. zargon

    zargon Community Moderator Forum Guru

    Messages:
    2,587
    Likes Received:
    362
    Trophy Points:
    1,430
    Location:
    Aurora, CO
    Set up a reminder in what application?