Filter all the data within current month

[Luca]

Hi All, 

I have a list of contracts in an excel file. 

I want to filter all the rows with "Start Date" up to the end of the current month. 

For example, the current month is April so I want to filter everything up to 30th Apr 2018.

Thanks,

Luca

[LordNeilLord]

Hey @Luca

Try this formula in the filter tool:

DateTimeFormat([Start Date], "%Y-%m") = DateTimeFormat(DateTimeToday(), "%Y-%m")

[Luca · Accepted solution]

I have just tried to use [Service Start Date]<=DateTimeLastOfMonth() and it seems to do the job. 

Is there anything I could potentially miss using this formula?

[LordNeilLord]

Oh Sorry, I thought you wanted just Aprils data!

In which case your formula will be fine

@LordNeilLord

Part time Tableau, Part Time Alteryx. Full Time Awesome

[dgoldrick]

If you wanted to keep it within the range of the current month you could add a conditional to the filter such as:

([Service Start Date] >= DateTimeFirstOfMonth()) AND ([Service Start Date] <= DateTimeLastOfMonth())

I get this was from around 4 years ago but if anybody sees this and needs it as a reference. Hope it helps!