How to convert string to date format

[wisnupo]

Hi, I’m confused about converting string data to date data. I have string data showing dates, but I’m confused about how to convert it to date format.

what node should I use to change it?

[rfeigel]

Check this out.

How Convert String to Date ( Date format in String 01-APR-2020

Please refrain from typing in all caps. It makes your post difficult to read. In the future, please also give details about what exactly you did. Just saying you tried a node doesn’t really give us much information. The specifics tend to matter. If you’d like to convert 01-APR-2021 to a KNIME date format, you’ll need to first convert the all caps abbreviated month to title case. That is, instead of “APR” it should be “Apr”. This can be done with the capitalize function in the String Manipulat…

[wisnupo]

Thank you so much @rfeigel

[takbb]

Hi @wisnupo , you may be interested in the following component that I built based on some of the ideas presented in the post that @rfeigel mentioned.

Parse Date&Time – takbb

The component attempts to convert any date. It just needs to be told what order to expect d, M, y in the string and tries to resolve it based on that information. It additionally includes a cutoff for how to treat 2 digit years.

… And that post in turn followed on from this post… For anybody who wants to geek out on date conversions

Writing a flexible Date Format handling workflow

Ever had one of those days when you just can’t get the string to date conversion to work for your workflow? I’ve seen a few questions on the forum about converting dates. Sometimes the format masks aren’t particularly intuitive, especially when coming to this new, which leads to time wasted by the person who just wants to make their workflow run without all the fuss! The java-based format masks aren’t always obvious in their meaning, and it occurred to me that it would be nice if there were a …

[wisnupo]

Yes thank you @takbb. I will use this component.

[wisnupo]

I’ve tried your component, and it’s really cool. I can finally change my data format.

[takbb]

thanks @wisnupo . Glad to hear it’s working