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 (fo…

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 recommen…

Or you can use the format date column: [Screenshot 2023-12-05 at 10.04.05 PM]

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

@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. :slight_smile: Darren, the formula with YYYY w…

Convert December 23, 2023 to 231223 (YYMMDD format)

Ask for Help

Darren_Murphy December 6, 2023, 3:08am 4

Not recommended, as it’s known to give inconsistent results on some devices under some circumstances.

Topic		Replies	Views
Day of the year Ask for Help	6	67	February 5, 2025
Changing Data format in Glide Table Ask for Help	4	782	July 3, 2021
📅 Guide on Dates & Times Community Resources	22	1711	April 2, 2025
Year only Ask for Help	1	328	December 29, 2022
Convert Date to Julian Date Format Ask for Help	4	729	July 29, 2022

Convert December 23, 2023 to 231223 (YYMMDD format)

Related topics