Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!

Alteryx Designer Desktop Discussions

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

Date Fomula

garretwalters12
8 - Asteroid

What formula can i use to have the 15h of the previous month for the current year.   ex. 2/15/2019

1 REPLY 1
MarqueeCrew
20 - Arcturus
20 - Arcturus
Left(DateTimeAdd(DateTimeFirstOfMonth(),-1,"Day"),8)+"15"

@garretwalters12 ,

 

That's last month's 15th.

 

Cheers,

 

Mark

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and restart. Order shall return.
Please Subscribe to my youTube channel.
Labels