# DateTime format after set column values

**URL:** <https://community.glideapps.com/t/datetime-format-after-set-column-values/43645>\
**Category:** Ask for Help\
**Created:** [June 28, 2022, 11:24pm UTC](https://community.glideapps.com/t/datetime-format-after-set-column-values/43645 "2022-06-28T23:24:58Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Miroslav\_Madaric](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/miroslav_madaric/32/20852_2.png) [@Miroslav\_Madaric](https://community.glideapps.com/u/Miroslav_Madaric)\
**Post date:** [June 28, 2022, 11:24pm UTC](https://community.glideapps.com/t/datetime-format-after-set-column-values/43645/1 "2022-06-28T23:24:58Z")

</div>

In one app I am using template for combining datetime&rowid. This i made correct with standard date formatting. In the set column value action after record adding I am copying this template field into spreadsheet text column. During this action Glide is changing the date format, making it unusable for sorting.

 ![date format](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/a/f/af88eb1f89c0e2580615cf6005d6f14851a1daf2.jpeg)

---

<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:** [June 29, 2022, 1:53am UTC](https://community.glideapps.com/t/datetime-format-after-set-column-values/43645/2 "2022-06-29T01:53:22Z")

</div>

For sorting a datetime column, sometimes it’s helpful to create a “datetime numeric value” using math column:  
`year(date)*10000000000+month(date)*100000000+day(date)*1000000+hour(date)*10000+minute(date)*100+second(date)`

---

<div class="post-metadata">

**Author:** ![Miroslav\_Madaric](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/miroslav_madaric/32/20852_2.png) [@Miroslav\_Madaric](https://community.glideapps.com/u/Miroslav_Madaric)\
**Post date:** [June 29, 2022, 9:13am UTC](https://community.glideapps.com/t/datetime-format-after-set-column-values/43645/3 "2022-06-29T09:13:25Z")

</div>

I am frustrated when I don’t solve such problem by myself! OK, 50 years ago I would do it in 1st minute. Maybe I am too much oriented on problem and not on solution: “I have problem for every solution!”.  
But this is still the workaround why set column value converts one date format to another?

Finally it would be fine that such workarounds are somehow used to fill in the FAQ database.

---

<div class="post-metadata">

**Author:** ![Miroslav\_Madaric](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/miroslav_madaric/32/20852_2.png) [@Miroslav\_Madaric](https://community.glideapps.com/u/Miroslav_Madaric)\
**Post date:** [June 29, 2022, 2:52pm UTC](https://community.glideapps.com/t/datetime-format-after-set-column-values/43645/4 "2022-06-29T14:52:39Z")

</div>

Checked, works perfect for X500 representation:

 ![X500](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/c/3/c336786ffd1af69f9af3bbea434287cb979f2b04.jpeg)

Next step: indent! 🙂