Hi,
This may be a relatively straightforward query but I have probably created a mess with my workflow (screenshot below). I have a data set with dates in string format that follow the dd-mmm-yy structure. I want to create an interface tool where the user select the date from the calendar window and on the basis of the date selected, the data in my dataset gets filtered.
As you can see, I have created a default filter for column "TRADE_DATE" to 13-Sep-23. I want the input from the date interface tool to replace that.
The problem here is that the date that comes from the date interface tool is in yyyy-MM-dd format and that is not in line with my dataset. Could you please dumb it down for me as to what I can to resolve this issue? Which tools need to be connected. A screenshot of the sample workflow would be greatly appreciated.
