8 Replies Latest reply on Jul 28, 2014 11:54 AM by Hudi

    First Date of Previous Month

    Hudi

      How would I find the first day of last month?

      Many of the calculations I've seen on this (and other) forums show this:

       

      Month ( Get(CurrentDate ) ) -1 & "/" & 1 & "/" & Year ( Get(CurrentDate ) )

       

      Which makes sense but does not accomodate for the month of January because you would end up with 0/1/2014, when it should be 12/1/2013.

       

      Thank you!