In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

Alteryx Designer Desktop Discussions

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

Date time struggles

chiragpatel_1
8 - Asteroid

Just been cheeky!

 

I have the below formula ad for some odd reason it is missing out the last day of May, (the 31st), what changes do i have to make in the formula

 

DateTimeMonth([Workflow Run])=DateTimeMonth(DateTimeNow())-1

 

//is it MTD?

 

very many thanks

3 REPLIES 3
binuacs
21 - Polaris

@chiragpatel_1 IF you are looking for the last day of the previous month you can use the formula 

binuacs_0-1654512599482.png

 

 

[Workflow Run] == DateTimeAdd(DateTimeToday(),-DateTimeDay(DateTimeToday()),'days')

 

chiragpatel_1
8 - Asteroid

Hi Thank you, just to clarify, i don't want the last day in isolation, but I want all the days so below there should be another line for 31st

 

chiragpatel_1_0-1654512701523.png

 

binuacs
21 - Polaris

@chiragpatel_1 yes, you need to use the >= in the filter condition. also please check your data has the date value 5/31?

 

binuacs_0-1654512907743.png

 

Labels
Top Solution Authors