Filter tool

[mihir_mir_jb]

Hello Everyone, 

I have a column in my excel file titled "Sent Date" which had dates of various months until the last month. So since this is the month of June it will have dates from Jan to May. I am trying to figure out how to filter on data where I can get records only for last month. And since this is going to be done month on month I cannot put a hard code month in the filter. Can you please advise on how to go about this. 

[Emil_Kos]

Hi @mihir_mir_jb,

I have created a workflow for you. First I would create a month column and then I would use join tool to show only the last month:

[Hollingsworth]

If your field is already a Date type, then you can use a simple filter tool with this expression:

DateTimeMonth([Send Date]) = datetimemonth(DateTimetoday())-1