Pizzor2000
08-25-2009, 08:15 AM
I am working with two dates: an annually recurring due date and the date a payment was made for a specific year. The two given dates may not be from the same year. What I want to do is figure out the date this particular payment was due by determining the first occurance of the given due date to come after the payment date.
Examples:
DueDate: 8/15/1991, Payment: 7/20/2005, Desired Result: 8/15/2005
DueDate: 7/1/2004, Payment: 6/22/1995, Desired Result: 7/1/1995
DueDate: 1/5/2001, Payment: 12/15/2007, Desired Result: 1/5/2008
Any thoughts on how I could do this through VB?
Examples:
DueDate: 8/15/1991, Payment: 7/20/2005, Desired Result: 8/15/2005
DueDate: 7/1/2004, Payment: 6/22/1995, Desired Result: 7/1/1995
DueDate: 1/5/2001, Payment: 12/15/2007, Desired Result: 1/5/2008
Any thoughts on how I could do this through VB?