convert string mmddyyyy to date column mmddyyyy

KNIME Analytics Platform
1

Hi Team,

I am trying to change the string column which is in MMDDYYYY eg: 05/27/2025
to date format using the string to date&time node but the output is changing to 2025-05-27.

please help me in resolving the issue.

Thanks,
Subbu.

2

Hi @Subramanya.

Take a look at this thread.

Best regards

3

Hi @hmfa

Sorry to say,

It didnt helped to solve my issue.
or else Please suggest me how to change Date format yyyy-mm-dd to Date format mm/dd/yyyy

Please treat this as critical.

Thanks,
Subbu

4

Hi @Subramanyam,
Could you attach a demo of your workflow to see what the issue is?

In the meantime, I have created an example of your situation according to your description. Does this workflow help? Example Date Conversion – KNIME Community Hub

Let me know!

5

Hi @BeauWN

Please find the below workflow and the input file.
and help me in resolving the issue.
I have gone through the workflow you have suggested but it did’nt helped me.

Thanks,
Subbu
Allocation Tracker OSAS_Report_2025-05-11_1224_PM.xlsx.xlsx (10.1 KB)
testing project.knwf (19.2 KB)

6

Thanks @Subramanyam for the Demo.

On my device, it now converts the date succesfully. I think the issue was that the input date format was not inserted corretly. If you press the guess data type and format button, it usually works just fine. Otherwise you need to input the format yourself. Hope it helps.

1 Like
7

Hi @BeauWN

thanks for your suggestions, but it is not working in my KNIME AP 5.4.3
It is turning to 2025-05-27

Please help how to resolve it.

Thanks,
Subbu

8

Ah I see, I misunderstood your question. As far as I know columns with the type ‘date’ are all formatted like this. Alternatively, you can keep two columns - your original, and the ‘date’ type -, one for calculation purposes and the other for your need. Then after doing the calculations, you can remove the ‘date’ type column. Would this work for you? Sorry, I am not aware of any more elegant solutions!

In this workflow, I have now created two columns: Solution Subramanyam – KNIME Community Hub

1 Like
9

Hi,

we are aware that the default format used for dates doe snot align with people expect in many/most parts of the world.
With the upcoming 5.5 release (planned for ~July) there will be quite some improvements to date and time support, including a Date Format Manager node. With that node you can set the output format of date-typed cells in tables without changing the underlying data. If you have the time, you can already try it in the nightly build. We are happy to hear your feedback.
As of now, and as described above, the only way to show dates in other formats is to turn them into a string using the Date&Time to String node.

Cheers,
nan

5 Likes
10

@nan Off-topic: where can we download the nightly build of Knime? Thanks

1 Like
11

Here: Nightly Builds Form | KNIME

2 Likes
12

Hi,

I’ve added the Date&Time to String node for your convenience — mostly for display purposes. I assume you’ll use it just to show the formatted date (e.g., MM-DD-YYYY), since the format itself doesn’t impact any analytical operations in KNIME.

If needed, you can also place this node at the very end of the workflow, as a loophole, just to present the date in a cleaner format.

Hope this helps!

Best,
Alpay
testing project 1_AZ.knwf (19.6 KB)

2 Likes