# Date Formatter (transform function)

**URL:** <https://community.parabola.io/t/date-formatter-transform-function/126>\
**Category:** Ask a question\
**Created:** [March 17, 2020, 9:58pm UTC](https://community.parabola.io/t/date-formatter-transform-function/126 "2020-03-17T21:58:39Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Dang\_Thai](https://avatars.discourse-cdn.com/v4/letter/d/aca169/32.png) [@Dang\_Thai](https://community.parabola.io/u/Dang_Thai)\
**Post date:** [March 17, 2020, 9:58pm UTC](https://community.parabola.io/t/date-formatter-transform-function/126/1 "2020-03-17T21:58:39Z")

</div>

I am using the Date Formatter converting YYYY-MM-DD HH:MM:SS to just MM-DD-YY.  
It seems to be working for some cells. [https://prnt.sc/ri1nh8](https://prnt.sc/ri1nh8)  
What am I doing wrong?

---

<div class="post-metadata">

**Author:** ![sachi](https://sea2.discourse-cdn.com/flex020/user_avatar/community.parabola.io/sachi/32/10_2.png) [@sachi](https://community.parabola.io/u/sachi)\
**Post date:** [March 17, 2020, 10:16pm UTC](https://community.parabola.io/t/date-formatter-transform-function/126/2 "2020-03-17T22:16:22Z")

</div>

Hi Dang! Can you try this in the Old Format: YYYY-MM-DD HH:mm:ss (lower case “mm” and “ss”)

You can find a list of our formatting options here: [https://parabola.io/transforms/date-conversion](https://parabola.io/transforms/date-conversion)

---

<div class="post-metadata">

**Author:** ![Dang\_Thai](https://avatars.discourse-cdn.com/v4/letter/d/aca169/32.png) [@Dang\_Thai](https://community.parabola.io/u/Dang_Thai)\
**Post date:** [March 17, 2020, 10:17pm UTC](https://community.parabola.io/t/date-formatter-transform-function/126/3 "2020-03-17T22:17:43Z")

</div>

> [@sachi](#):
>
> mm:ss

Thank you Sachi, that worked like a charm!