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
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
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