Filter the last day of the month

[louyang]

Hi,

I have a number of data containing random dates from one month, extracting from a monthly report. I wanted to use a filter tool to always select the last day of the month. I was using the formula:

DateTimeAdd(DateTimeTrim([Posting Date], "month", "end"), 0, "days")

But this didn't work in Alteryx, seems the formula missesd something.

I'm now using a 'Sort' tool, to sort the last day to the top, then a 'Select Records' tool to select the top one, but this process doesn't feel as secure as a formula does, please help, thank you.

[flying008 · Accepted solution]

Hi,@louyang 

FYI.

[Date] = TODATE(DateTimeTrim([Date],'lastofmonth'))

[nagakavyasri · Accepted solution]

@louyang Another way: