If my understanding about your query is correct, you are expecting the incoming date to be in any format and you would like to convert them to a standardized output format.
If you are using Talend Studio, it expects the incoming date in a specific format else you will have to write a marathon list of all possible combinations to convert the date to a standardized format.
But there is an easy solution if you are using subscription version of Talend where you can use Talend Data Preparation to do the cleansing activity. You can create a rule in the Talend Data Preparation recipe where you want to standardize the incoming date. This recipe will be called from Studio to perform the cleansing and you will get standard date in the output.
Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂
