Action Flow filter date

Hi Junwei, 
 

When querying data from Celonis in an action flow, you can scroll down to the ‘Filter’ section of the module. Here you can select a predefined filter in the KM you are working with that filters the dates, or you can write a filter inside the module by changing ‘Filter Type’ to ‘Custom Filter’.

Hi ​@andrew.cirin11,

Thanks for the replies. I have found filter section but am unsure which formula should use to filter out as I did not use KM before. Could you please guide me more about this? Thanks

Hi Junwei,

Apologies for the late response. You can create a formula for this action which can be something like this:

FILTER <table.datecolumn> BETWEEN {d '2024-11-01' } AND {d '2024-12-01' };

You can read more about the BETWEEN function here: https://docs.celonis.com/en/between.html

Hi Andrew,

Ok understood. I have managed to solve this now 

Thank you!