Dynamic filter in automation

[martinpohl]

Hi,

can anybody explain how to set a dynmic filter in application automation?

I want to select in field Year month the value of actual month, in expression it would be date(today(),'YY MMMM').

Thank you

[Ionut_Dumitrascu]

Hi @martinpohl ,

In order to dynamically get the current year - month, you can use the following formula: 

{date: 'now', 'Y-m'}

 where 'now' gets the current date value and 'Y-m' is the output format which can be adjusted to match your needs. I also attached an example that you can upload in a new automation to check it out.

Regards,

Ionut

[Ionut_Dumitrascu]

Hi @martinpohl ,

Please also check the following articles that explain how to work with formulas and dates in an automation.

Kind regards,
Ionut

[martinpohl]

Great, first check was ok.

But there is a problem with date format.

I'm using

date(monthstart(Usingdate),'MM YYYY') as MonthYear.

when I'm using now and format mm yyyy, it doesn't work.

I've checked the values in valuelist (do lookup). There I can see:

12 2021 (44531)

11 2021 (44501)

As I know, date and month information in fields are stored as dual, so you can see the day also in the value.

How can I achive to select the actual month by "select field value"?

Regrads

[martinpohl · Accepted solution]

after changing to 

text(date(monthstart(Usingdate),'MM YYYY')) as MonthYear

and set filter to

m 20y

it works!