Taking Filter Input from Calendar Interface

[hemant86]

Hi Team,

I'm trying to take a filter input from user where the user will select the date from Calendar interface and the workflow will filter the entered date from the database and give the extract. Now the problem here is, my database has the dates in mm-dd-yyyy format while the Calendar Interface enters the date in yyyy-mm-dd. Hence its not filtering out any records.

Any workaround to enter the date in mm-dd-yyyy format through Calendar interface? 

Thanks in Advance!

[atcodedog05]

Hi @hemant86 

You won't directly be able to use it. Instead generate the date in a formula tool and pass it to a dynamic input tool SQL where clause to read.

App to get date format:

for how to pass it to a dynamic input tool SQL where clause to read

https://www.youtube.com/watch?v=ELfKYatOJZM refer (8:16 minute)

Hope this helps : )

[hemant86]

Thanks @atcodedog05 for your inputs. I will try that out.🙂