• Calculate Previous Year Date

    Author
    Topic
    #458088

    Hi,
    I have a control [txtDate] that the user enters the last day of the month for which they need a report. I need a formula to find the same date for the previous year (that also takes into account leap year). So if they enter 2/28/2009 the result from the formula would be 2/29/2008.

    Thanks,
    Alicia

    Viewing 0 reply threads
    Author
    Replies
    • #1150605

      Leesha,
      use : DateAdd(“yyyy”,-1,[txtDate])
      to find the exact date 1 year ago from [txtDate]

    Viewing 0 reply threads
    Reply To: Calculate Previous Year Date

    You can use BBCodes to format your content.
    Your account can't use all available BBCodes, they will be stripped before saving.

    Your information: