Tutorials & Examples Web-help Blog

Get last day of prior month


#1

Hello,

I am trying to figure how to create a column that will return the last day of the prior month.
examples:

1/18/2019 - return 12/31/2018
1/28/2019 - return 12/31/2018
2/18/2019 - return 01/31/2019


#2

Hi @deezfroggielipz and welcome to the Community!

To calculate a new column use the “Calculate column” action. The resulting expression would be as follows:

monthstart([Current Date]) - 1

The monthstart() function obtains the first day of month for the provided date.

Then subtract 1 to obtain the previous day. Note that dates in EasyMorph are numbers, like in Excel. See more about dates here: Type system and expressions