Date & Time :: Date functions

On this page you will find several functions for calculating dates.

7 days from a nominated date

    'Forward in time
        myDate = Date + 7
        myDate = DateAdd("d", 7, dte)

    'Backwards in time
        myDate = Date + -7
        myDate = DateAdd("d", -7, dte)

7 weeks from a date

    'Forward in time
        myDate = DateAdd("ww", 7, dte)

    'Backwards in time
        myDate = DateAdd("ww", -7, dte)

7 months from a date

    'Forward in time
        myDate = DateAdd("m", 7, dte)

    'Backwards in time
        myDate = DateAdd("m", -7, dte)

7 quarters from a date

    'Forward in time
        myDate = DateAdd("q", 7, dte)

    'Backwards in time
        myDate = DateAdd("q", -7, dte)

7 years from a date

    'Forward in time
        myDate = DateAdd("yyyy", 7, dte)

    'Backwards in time
        myDate = DateAdd("yyyy", -7, dte)

Odd year prior to even year, or same year if current year is odd

        myDate = DateSerial(Year(dte) + (Year(dte) Mod 2 = 0), 1, 1)