Date Formats

[takbb]

Hi @Ramakant_Patil , with date formats which are sufficiently different that they can be identified with no ambiguity, you can use multiple format masks within a single String to Date&Time node…

See my previous post (below) for an example. You simply place each format sequentially in square brackets but place them in the order that correctly identifies each format. On my mobile phone at the moment so can’t easily write example for your data but if you need further assistance let me know and I’ll take another look when back on my pc…

how to convert 2 date format in one

Hi @nisha_rathi , you’re welcome. The above was the general answer to handling multiple formats but on further thought there was a simpler solution and it could be achieved with a single String to Date&Time node using the following format mask instead: [yyyy-MM-dd][dd-MM-yyyy] The square brackets make parts of the mask optional and so the node would be able to work with both your formats in one go.

By the way, for the dates with month names, will September be Sep or Sept? You’ll need to set the locale correctly to handle that one month. Eg if “Sep” you could set locale to en-US, but if it’s “Sept”, set it to en-GB