Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
SOLVED

Get Previous Month first day at any given date

msedrech0114
7 - Meteor

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

2 REPLIES 2
AdamR
Alteryx
Alteryx

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

 

 

Adam Riley
Principal Software Engineer
Tech Lead Core Engines, Alteryx
msedrech0114
7 - Meteor

Thank you AdamR! your formulars work!

Labels