date based on numeric month
I am trying to calculate a date based on a month. We have certifications that expire not based on the date that the certificate was issued, but on a specific month of the year. This is called a "base ...
Forum Discussion
I've been using comments (I have an incredibly meager amount of experience with java and robotC) which helps me keep track of what is going on, but the biggest problem I am having now is defining exactly what I want a formula or series of formulas to do and determining the best course of action to solve the problem. Now that I have the creation of expiration dates working I need to go back and compare multiple records for a single person that may or may not have overlapping dates and then determine if all of their certificates are valid. Right now we are doing this by hand, but it leads to human error mistakes . I would like to automate it, but i'm not sure how to even define exactly what I am doing.