ME» ñUse Get Next Day macroNþ&;ÈXã@Ÿ à?ÿðWã@e\Ô(éÿï?àWã@€…ã@>==============================================================T"Macro - Use Get Next Day macroTQFunction - Calls the 'Get Next Day' macro to demonstrate how to get the next dateT*Company - Insight Software Solutions, Inc.TAuthor - Kevin HeatonT>==============================================================T TUses:T T3 - DayT T4 - MonthT T5 - YearT N3 - DayT N4 - MonthT N5 - YearT D5 - YearT N6 - Number Of days In MonthT& N7 - Temporary calculation variableT& T7 - Temporary calculation variableT T%After calling the macro Get Next Day:T T1 - Date In DD/MM/YY FormatT T2 - Date In MM/DD/YY FormatT T>==============================================================TTSet test data to 15 June 2008T|15T|06T|2008TT'Run the macro to calculate the next dayT3 Get Next DayT6ûT1CenterCenter000340000220000Result: Get Next Day Result of calling Get Next Day with the date 15 June 2008 %T1% - DD/MM/YY format %T2% - MM/DD/YY format %T3% - Resulting Day %T4% - Resulting Month %T5% - Resulting YearTTT-Repeat the test for the date 28 February 2008T|28T|02T|2008TT'Run the macro to calculate the next dayT3 Get Next DayT6ûT1CenterCenter000340000220000Result: Get Next DayResult of calling Get Next Day with the date 28 February 2008 %T1% - DD/MM/YY format %T2% - MM/DD/YY format %T3% - Resulting Day %T4% - Resulting Month %T5% - Resulting YearTTT-Repeat the test for the date 29 February 2008T|29T|02T|2008TT'Run the macro to calculate the next dayT3 Get Next DayT6ûT1CenterCenter000340000220000Result: Get Next DayResult of calling Get Next Day with the date 29 February 2008 %T1% - DD/MM/YY format %T2% - MM/DD/YY format %T3% - Resulting Day %T4% - Resulting Month %T5% - Resulting YearTTT-Repeat the test for the date 31 December 2008T|31T|12T|2008TT'Run the macro to calculate the next dayT3 Get Next DayT6ûT1CenterCenter000340000220000Result: Get Next DayResult of calling Get Next Day with the date 31 December 2008 %T1% - DD/MM/YY format %T2% - MM/DD/YY format %T3% - Resulting Day %T4% - Resulting Month %T5% - Resulting YearTTT-Repeat the test for the date 28 February 2009T|28T|02T|2009TT'Run the macro to calculate the next dayT3 Get Next DayT6ûT1CenterCenter000340000220000Result: Get Next DayResult of calling Get Next Day with the date 28 February 2009 %T1% - DD/MM/YY format %T2% - MM/DD/YY format %T3% - Resulting Day %T4% - Resulting Month %T5% - Resulting YearTTT-Repeat the test for the date 29 February 2009T|29T|02T|2009TT'Run the macro to calculate the next dayT3 Get Next DayT6ûT1CenterCenter000340000220000Result: Get Next DayResult of calling Get Next Day with the date 29 February 2009 %T1% - DD/MM/YY format %T2% - MM/DD/YY format %T3% - Resulting Day %T4% - Resulting Month %T5% - Resulting YearT\BáB