# Convert December 23, 2023 to 231223 (YYMMDD format)

**URL:** <https://community.glideapps.com/t/convert-december-23-2023-to-231223-yymmdd-format/68398>\
**Category:** Ask for Help\
**Created:** [December 6, 2023, 2:48am UTC](https://community.glideapps.com/t/convert-december-23-2023-to-231223-yymmdd-format/68398 "2023-12-06T02:48:50Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![gannonatwork](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gannonatwork/32/91717_2.png) [@gannonatwork](https://community.glideapps.com/u/gannonatwork)\
**Post date:** [December 6, 2023, 2:48am UTC](https://community.glideapps.com/t/convert-december-23-2023-to-231223-yymmdd-format/68398/1 "2023-12-06T02:48:50Z")

</div>

Hello. Here’s what I’m trying to do:

Column A: Date column set to Date Only \> Medium format or “December 23, 2023”  
Column B: need to get/copy the values in Column A (each row separately), convert these values from “December 23, 2023” to “231223” and then write the converted value to Column B (for all rows individually)

My assumption is using a Math column would be the most efficient using a formula, but I don’t have any idea what the formula would be? Any help would be greatly appreciated. Thx

---

<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 6, 2023, 2:59am UTC](https://community.glideapps.com/t/convert-december-23-2023-to-231223-yymmdd-format/68398/2 "2023-12-06T02:59:29Z")

</div>

```auto
Mod(Year(Date),2000)*10^4
+ Month(Date)*10^2
+ Day(Date)

```

ps. I should add that the above won’t work for dates prior to 2000, or after 2099. But if you have dates outside that range, then using YYMMDD format is going to break anyway.

If you want something that works for _all_ dates, then I’d recommend YYYYMMDD format, in which case the formula would be:

```auto
Year(Date)*10^4
+ Month(Date)*10^2
+ Day(Date)

```

---

<div class="post-metadata">

**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\
**Post date:** [December 6, 2023, 3:05am UTC](https://community.glideapps.com/t/convert-december-23-2023-to-231223-yymmdd-format/68398/3 "2023-12-06T03:05:02Z")

</div>

Or you can use the format date column:

 ![Screenshot 2023-12-05 at 10.04.05 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/e/3/e3ab19c1e37b2be675de2b523da566cfbaa5ab15.jpeg)

---

<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 6, 2023, 3:08am UTC](https://community.glideapps.com/t/convert-december-23-2023-to-231223-yymmdd-format/68398/4 "2023-12-06T03:08:02Z")

</div>

Not recommended, as it’s known to give [inconsistent results](https://community.glideapps.com/t/time-format/50074/8) on some devices under some circumstances.

---

<div class="post-metadata">

**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\
**Post date:** [December 6, 2023, 3:09am UTC](https://community.glideapps.com/t/convert-december-23-2023-to-231223-yymmdd-format/68398/5 "2023-12-06T03:09:16Z")

</div>

same as math…but i agree that math column for some reason, handles this better… that’s why I always trust the Javascript column the most… i get the current time from Java and then all the formating goes from there

---

<div class="post-metadata">

**Author:** ![gannonatwork](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gannonatwork/32/91717_2.png) [@gannonatwork](https://community.glideapps.com/u/gannonatwork)\
**Post date:** [December 6, 2023, 3:34am UTC](https://community.glideapps.com/t/convert-december-23-2023-to-231223-yymmdd-format/68398/6 "2023-12-06T03:34:23Z")

</div>

@Darren_Murphy and @Uzo Thank you both for taking the time share your expertise and responding so quickly! This is a huge help. Too bad the Format Date function doesn’t work consistently as that’s a little more straightforward for us non-formula lads. 🙂

Darren, the formula with YYYY works perfect…thanks again, much appreciated.

---

<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 13, 2023, 3:34am UTC](https://community.glideapps.com/t/convert-december-23-2023-to-231223-yymmdd-format/68398/7 "2023-12-13T03:34:32Z")

</div>

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