Get Previous Month first day at any given date

Can anyone help I want to add a formula expression that would get the first day and last day of previous month of a given date field.

e.g

Field_1: 2018-05-05

Output_1: 2018-04-01

Output_2: 2018-04-30

In sql, there's an expression to handle this case but can't find a solution yet in Alteryx.

Appreciate any help in advance.

Mark

Accepted answers

I think these formulas do what you want:

Previous Month = DateTimeAdd([OriginalDate],-1,"month")

FirstOfPreviousMonth = DateTimeAdd([Previous Month], 1-DateTimeDay([Previous Month]), "days")

LastOfPreviousMonth = DateTimeAdd([OriginalDate], 0-DateTimeDay([OriginalDate]), "days")

I think these formulas do what you want:

Previous Month = DateTimeAdd([OriginalDate],-1,"month")

FirstOfPreviousMonth = DateTimeAdd([Previous Month], 1-DateTimeDay([Previous Month]), "days")

LastOfPreviousMonth = DateTimeAdd([OriginalDate], 0-DateTimeDay([OriginalDate]), "days")

Thank you AdamR! your formulars work!

Try this

DateTimeAdd(DateTimeLastOfMonth(),-2,"months")