# Convert date format

**URL:** <https://community.parabola.io/t/convert-date-format/3259>\
**Category:** Ask a question\
**Created:** [April 16, 2025, 10:11pm UTC](https://community.parabola.io/t/convert-date-format/3259 "2025-04-16T22:11:42Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![eddie](https://sea2.discourse-cdn.com/flex020/user_avatar/community.parabola.io/eddie/32/1707_2.png) [@eddie](https://community.parabola.io/u/eddie)\
**Post date:** [April 16, 2025, 10:11pm UTC](https://community.parabola.io/t/convert-date-format/3259/1 "2025-04-16T22:11:42Z")

</div>

I’m trying to convert the format of two date columns from Jan 25, 2022 6:11 PM to 2022-01-25 18:11:00

Here is a screenshot of how I have it setup in Parabola…

 ![Screen Shot 2025-04-16 at 6.00.50 PM](https://us1.discourse-cdn.com/flex020/uploads/parabola/original/2X/8/88eeae296a42551b02dae596ea24704ff2ae32d1.png)

Even after updating results, the format of the two date columns hasn’t changed. Any suggestions?

Much appreciated.

---

<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:** [April 18, 2025, 8:35pm UTC](https://community.parabola.io/t/convert-date-format/3259/2 "2025-04-18T20:35:31Z")

</div>

Hey @eddie - This is interesting. It looks like our format date step is case sensitive in an unexpected way so I will flag this with our engineering team.

In the meantime, if you use a Find/Replace step to replace lowercase “am” “pm” with uppercase “AM” “PM” and then use the Format Dates step as formatted below, that should do the trick! Let us know how that goes.

 ![Screenshot 2025-04-18 at 3.34.30 PM](https://us1.discourse-cdn.com/flex020/uploads/parabola/original/2X/1/18dcf9965f065ee17b191449bb89de0b24067f58.png)

---

<div class="post-metadata">

**Author:** ![eddie](https://sea2.discourse-cdn.com/flex020/user_avatar/community.parabola.io/eddie/32/1707_2.png) [@eddie](https://community.parabola.io/u/eddie)\
**Post date:** [April 18, 2025, 10:16pm UTC](https://community.parabola.io/t/convert-date-format/3259/3 "2025-04-18T22:16:01Z")

</div>

Thanks @sachi! That did the trick.

The only additional change I had to make was to remove one “d” from the “From this format”. Leaving it as “dd” was causing any single digit date (any day earlier than the 10th of the month) from being formatted (the formatting would fail for that row).

Here is the screenshot of what worked…

 ![Screen Shot 2025-04-18 at 6.12.40 PM](https://us1.discourse-cdn.com/flex020/uploads/parabola/original/2X/5/55742d9fbe27ddd3d833b85f4978d10d50c7d76f.png)

---

<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:** [April 21, 2025, 1:47pm UTC](https://community.parabola.io/t/convert-date-format/3259/4 "2025-04-21T13:47:06Z")

</div>

Ah, that makes sense! Thanks for following up with the screenshot, @eddie