# Changing string type date into date datatype

**URL:** <https://forum.knime.com/t/changing-string-type-date-into-date-datatype/77462>\
**Category:** KNIME Analytics Platform\
**Created:** [February 24, 2024, 6:44pm UTC](https://forum.knime.com/t/changing-string-type-date-into-date-datatype/77462 "2024-02-24T18:44:12Z")\
**Posts on this page:** 1\
**Showing post:** 8

<div class="post-metadata">

**Author:** ![mlauber71](https://forum-cdn.knime.com/user_avatar/forum.knime.com/mlauber71/32/73590_2.png) [@mlauber71](https://forum.knime.com/u/mlauber71)\
**Post date:** [February 25, 2024, 5:38am UTC](https://forum.knime.com/t/changing-string-type-date-into-date-datatype/77462/8 "2024-02-25T05:38:28Z")

</div>

@nikhil_r you can provide a [fitting pattern](https://docs.oracle.com/javase/8/docs/api/java/time/format/DateTimeFormatter.html) for your date string. Maybe you can show some examples

> [@Error in Conversion of String format to Date format](https://forum.knime.com/t/error-in-conversion-of-string-format-to-date-format/75994/13):
>
> Hi @PKRISH , please note that the case is important. You need to be careful to use the examples as they were given. So the year yyyy remains lower case. i.e. the format is: dd-MM-yyyy or d-M-yyyy (or variations of those) The single d and single M allow for day and month both as single digit, or double digit or with leading zero. If you specify dd or MM it only matches where the day / month is represented as 2 digits. i.e. d and M are less restrictive than dd and MM It’s not entirely obvio…

> **[Date & Time Integration | KNIME](https://www.knime.com/blog/the-new-date-time-integration/)**
>
> This article describes the date&time integration in KNIME offering time zone and multiple columns support, flexibility measuring time differences, auto-guessing string formats, and flow variable support.

---

_[View the full topic](https://forum.knime.com/t/changing-string-type-date-into-date-datatype/77462)._