Student1000
05-18-2010, 09:37 AM
Hey everybody,
I have the following problem with my travel agency VBA program:
the user can indicate his arrival and departure date via a pop up calendar.
However, I have to compare the data the user entered with the data in my Database (we are talking about ski resorts opening seasons). This means, I need to check whether the dates the user entered (arrival and departure) lie within the season of a respective ski resort. However, I saved the ski resort Season data in the format dd.mm.2010. The problem is that the duration of a ski season is spread over 2 consecutive years.
If I assume that the season start and ending dates never change, can anyone tell me how i can check whether the arrival and departure date the user entered correspond with the season dates (especially because i have different years e.b. 2010/11, 2011/12, 2012/13). The value in the calculation sheet should be 1 if the dates of the user are within a season and 0 otherwise.
thanks for any help in advance!
I have the following problem with my travel agency VBA program:
the user can indicate his arrival and departure date via a pop up calendar.
However, I have to compare the data the user entered with the data in my Database (we are talking about ski resorts opening seasons). This means, I need to check whether the dates the user entered (arrival and departure) lie within the season of a respective ski resort. However, I saved the ski resort Season data in the format dd.mm.2010. The problem is that the duration of a ski season is spread over 2 consecutive years.
If I assume that the season start and ending dates never change, can anyone tell me how i can check whether the arrival and departure date the user entered correspond with the season dates (especially because i have different years e.b. 2010/11, 2011/12, 2012/13). The value in the calculation sheet should be 1 if the dates of the user are within a season and 0 otherwise.
thanks for any help in advance!