Filter for current month automatically

[limats]

Hi,

I am trying to filter data from an excel file for a certain month. I currently filter for the string data in a column with YYYYMM format manually using the filter tool. 

Is there a way for when I run the workflow to automatically pick up say the current month's data? E.g If I ran this in March 2021, I would only see data for 202103?

YearMonth	Date
202101	1/29/2021
202101	1/29/2021
202102	2/26/2021
202102	2/26/2021
202101	1/29/2021
202101	1/29/2021
202101	1/29/2021
202101	1/29/2021
202102	2/26/2021
202102	2/26/2021
202102	2/26/2021
202102	2/26/2021
202101	1/22/2021
202101	1/22/2021
202102	2/10/2021
202101	1/29/2021
202101	1/29/2021
202101	1/29/2021
202101	1/29/2021
202102	2/26/2021
202102	2/10/2021
202102	2/26/2021
202103	3/18/2021

[mst3k · Accepted solution]

use this formula in your filter, assuming yearmonth is a string

yearmonth=datetimeformat(datetimenow(),'%Y%m')

if it's not a string, you can use tostring or tonumber functions

[limats]

Thank you for the super fast response. 

[LVLEGUIZAMONH]

Hola, podrias ayudarme porfavor!

Necesito que Alteryx, automaticamente reconozca el mes actual y sume los valores del mes actual.