# Noob Help: Convert date value to dd/mm/yyy **URL:** \ **Category:** KNIME Analytics Platform\ **Created:** [November 29, 2019, 12:22am UTC](https://forum.knime.com/t/noob-help-convert-date-value-to-dd-mm-yyy/19757 "2019-11-29T00:22:51Z")\ **Posts on this page:** 1\ **Showing post:** 4
**Author:** ![quaeler](https://forum-cdn.knime.com/user_avatar/forum.knime.com/quaeler/32/3944_2.png) [@quaeler](https://forum.knime.com/u/quaeler)\ **Post date:** [November 29, 2019, 3:38am UTC](https://forum.knime.com/t/noob-help-convert-date-value-to-dd-mm-yyy/19757/4 "2019-11-29T03:38:34Z")
Great - there’s the magic secret… according to [this](https://excel.officetuts.net/en/training/how-excel-stores-date-and-time) the epoch is new year’s day 1900, and each number is a day since. You could use the date & time shift node - but that seems like a pain in the ass. Here’s a workflow. Perhaps you could export the dates in a different format (like an YYYYMMDD string or milliseconds since epoch or …) for which there are nodes that do this conversion specifically. [plunket excel number to date.knwf](https://forum-cdn.knime.com/uploads/default/original/2X/4/4be6cc222cccf2130fb7f644e209d45919fdc310.knwf) (6.8 KB) --- _[View the full topic](https://forum.knime.com/t/noob-help-convert-date-value-to-dd-mm-yyy/19757)._