Between two dates.

Hello everyone,

I am trying to get an output if it matches a time between tow dates.

So let's say the date is between 2019-06-13 - 2019-07-12, then th out put needs to be A. And if the date is between 2019-07-13 - 2019-08-12 then the output needs to be B. And etc. etc. 

Does anybody know a way to do this? 

Thanks in advance for all the help!

There are a number of inbuilt date converters and functions available that will allow you to do this.

If you take your input date and run it through a 'Get Times between Dates' converter this will give you the number of days between your input and target date. Assign this to a difference variable, then do the same for your second date. When configuring your converter make sure you check the 'Get Signed Difference' checkbox to give you negative values for the date differences.

You can then check if your input date lies between the two by making sure one is positive and the other negative. If it fails then repeat the process for the second set of dates and return the output accordingly.

Setting up the converters.. assign the results to DateDiff1 and DateDiff2 variables.




Add a test against the two differences, if it matches then output A otherwise try again for the next set of dates. If that one doesn't match then do some error handling. Tests are just test actions using

Hi and thank you Batman!

I thought about this but since the input will be text i couldnt use it.

I used instead converters and IF THEN where i used MATCH PATTERN:
^(202)\d([-])(1[2])\2(0[1-9]|[1][0-7])$

Which worked very smoothly.