Help! I have been pondering for days and searched the forums but still don't have a clue on how to make my function work despite trying a few solutions provided here. At my wits end!
I have 5 rows of dates, namely Date1, Date2, Date3...& so on which is an input field by the user. I want to make a comparison against a date range, StartDate1 & EndDate1, StartDate2 & EndDate2, StartDate3 & EndDate3...etc which is sort of a setup table by the Administrator of the application. I want to make sure that all the input dates falls within the date range.
Eg, if input date is 01/01/2008 (row 1), 02/01/2008 (row 2), 31/06/2008 (row 3) by user and the table range is >
DateRange 1 > 01/04/2007 - 31/03/2008
DateRange 2 > 01/04/2008 - 31/03/2009
DateRange 3 > 01/04/2010 - 31/03/2011
Here row 3 is out of the date range the other date inputs fall under DateRange 1, how do I throw an error message saying that input range must be within the date range??
Thanks in advance!