How can i select a specific dates in the input step ?

[ahmad]

Dear all,

How can I select a specific dates in the input step ?

knowing that if I select all the dates it takes so much time to get the data because its too huge and i want let say all the EOM for 2021 

Thanks all and Regards 

[atcodedog05]

Hi @ahmad 

Filter to data can only be applied for SQL db input types. For file type you need to read all data and then apply filters.

For SQL db you can apply filter in the query where condition.

Hope this helps : )

[atcodedog05 · Accepted solution]

Hi @ahmad 

You can use a workflow like below to calculate EOM for the previous year compare and filter it out.

Workflow:

Hope this helps : )

[ahmad]

thanks so much for your response it's worked .

[atcodedog05]

Happy to help : ) @ahmad 

Cheers and have a nice day!