please wait

  • Jignesh Patel Mar-12-2019 08:59:34 AM ( 2 months ago )

    I currently have use the following code to give me the date of today as yyyymm.

    Today = FORMAT(TODAY(), "yyyymm")

    The problem is that I need to get the same format yyyymm for 6 months from now

    So if today is 201903, I need 201909.

    I have been able to return the month, 6 months from now with:

    6MonthsFromNow = MONTH(TODAY()) + 6

    But that doesn't really help me as I need the year and month as yyyymm

Please login

Similar Discussion

Recommended For You