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!

No, dsvail's answer is

notcorrect, and Hudi's correction is appropriate – which can easily be seen with better formatting:dsvail's version:

Date (

Month (Get ( CurrentDate ) -1) ;

1;

Year (Get ( CurrentDate ))

)

where just the first line ( month argument) is

Month (

Get ( CurrentDate ) -1

)

which is the month of yesterday's date, not the last month (or if so, then only by accident).

Correct is

Month ( Get ( CurrentDate ) ) - 1or in toto:

Let (

cd = Get ( CurrentDate ) ;

Date ( Month ( cd ) - 1 ; 1 ; Year ( cd ) )

)