AnsweredAssumed Answered

First Date of Previous Month

Question asked by Hudi on Jul 28, 2014
Latest reply on Jul 28, 2014 by 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!

Outcomes