# Wrong date format

**URL:** <https://community.glideapps.com/t/wrong-date-format/55294>\
**Category:** Ask for Help\
**Created:** [December 1, 2022, 1:53pm UTC](https://community.glideapps.com/t/wrong-date-format/55294 "2022-12-01T13:53:51Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Monika](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/monika/32/49427_2.png) [@Monika](https://community.glideapps.com/u/Monika)\
**Post date:** [December 1, 2022, 1:53pm UTC](https://community.glideapps.com/t/wrong-date-format/55294/1 "2022-12-01T13:53:51Z")

</div>

Hello,

date in date column is in american format but our app needs european format.

12.1.2022 (today´s import) but it should be 1.12.2022

Is there any way to change the format from YYYYMMDD to DDMMYYYY in date column?

Thank you,

Monika

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [December 1, 2022, 2:27pm UTC](https://community.glideapps.com/t/wrong-date-format/55294/2 "2022-12-01T14:27:27Z")

</div>

The displayed date format should respect the users device/browser regional settings.  
If you’re seeing US date format in the builder, that most likely means that your browser is configured to use US date format.

The only way to force a date format is to convert the date to a string. The Format Date column will do this, although personally I don’t normally recommend using it as I’ve seen it give inconsistent results.

The other way would be to break the date into its component parts using math columns, and then piece it back together using a template (this is my preferred method).

---

<div class="post-metadata">

**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\
**Post date:** [December 1, 2022, 2:28pm UTC](https://community.glideapps.com/t/wrong-date-format/55294/3 "2022-12-01T14:28:03Z")

</div>

You can use the format date column if it’s for display purposes only:

 ![CleanShot 2022-12-01 at 09.27.48](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/3/6/36537ba09c4f4d1a99c43610cb4c32597797fef3.jpeg)

---

<div class="post-metadata">

**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\
**Post date:** [December 2, 2022, 2:28pm UTC](https://community.glideapps.com/t/wrong-date-format/55294/4 "2022-12-02T14:28:10Z")

</div>

This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.