Free Trial

Alteryx Designer Desktop Discussions

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

filter by actual month

LETICIAHELENA
8 - Asteroid

How Can I apply a filter when I just always the actual month?

 

In my report has month 3 and 4 but I just number 4 and when change to May also need update.

 

LETICIAHELENA_0-1680657537342.png

 

3 REPLIES 3
PangHC
12 - Quasar

by using these 2 formulas.

Pang_Hee_Choy_0-1680658299393.png

Pang_Hee_Choy_1-1680658351438.png

 

DateTime Functions | Alteryx Help

Luke_C
17 - Castor
17 - Castor

Like @PangHC  suggested:

 

DateTimeMonth([Data Inicio]) = DateTimeMonth(DateTimeNow())
PhilipMannering
16 - Nebula
16 - Nebula

For just two months, the above solution will work. The same months from different years will also evaluate to True. If this is a problem, you could use,

DateTimeTrim([Data Inicio], 'month') = DateTimeFirstOfMonth()
Labels
Top Solution Authors