prompt for date -intreface tools

[Redzapplin]

Hi there,

I am looking to build a mechanism where in i get a prompt using an interface tools to input high and low date fields while running it form gallery. Input fields should be in a format like 001.2020 where 001 is the month and 2020 is the year. Can any one assist me on this?

[Redzapplin]

HI @atcodedog05 

Is there any workaround for this? it seems my requirement will not get fulfilled. 😔

[atcodedog05]

Hi @Redzapplin 

What's the requirement and expected output.

[Redzapplin]

Basically, i will need a prompt as an input for low and high so that whenever i get a requirement from my stakeholders that they want to see the data between low(March) to high(September) which is "003.2020 to 009.2020" or from low(April) to high(December) which is "004.2020 to 012.2020" - i should get my output same as input.

Please note I am going to use this mechanism in ACS connector

 

[atcodedog05]

Hi @Redzapplin 

Here is a modified workflow for the task.

Output:

Hope this helps 🙂 Feel to ask if you have any questions

If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

[Redzapplin]

Hi @atcodedog05,

Thanks much. But if I change the input to some there dates, some works some doesn't. Strange! 

 

[atcodedog05]

Hi @Redzapplin 

You sure date ranges are there which meets the condition. Your sample date would not meet the condition.

[Redzapplin]

Yes I am very sure about it.

[atcodedog05]

Hi @Redzapplin 

I added some sample data to meet condition and its working for me.

Please do check and let me know🙂

[Redzapplin]

It works for 002 to 004 but not for 004 to 009. It should be kind of dynamic, like if we fall into 2021 it should take those period into consideration without listing all the years(2021,2022,2023) in sample input data. whichever period input i use in prompt should show same output.

[atcodedog05 · Accepted solution]

Hi @Redzapplin 

Oh ok its like between range [low]>= values >=[high]

Here is the output:

Please check and let me know