Hi… I figured out that +thisRow.[Enter date].format("{1:00}/{2:00}", Day(thisRow.[Enter date]), Month(thisRow.[Enter date])) would give me 05/20 but if I try to add year I get an unexpected result: +thisRow.[Enter date].format("{1:00}/{2:00}/{3:00}", Day(thisRow.[Enter date]), Month(thisRow.[Enter…

Date format mm/dd/yy in formula?

Martin_Portevin June 6, 2022, 5:06pm 2

Hi @Gregg_Stebben , not sure what the problem is, but I just put together a sample that might be what you’re looking for:

2 Likes

Reformat date and time with now()

Topic		Replies	Views
Change D/M/YYYY to YYYY-MM	3	457	July 31, 2023
How to format dates inside a formula syntax?	4	2297	January 26, 2020
Date Format in Coda	4	978	October 27, 2021
Strange date formats	1	464	February 25, 2019
Date format error with formula field	4	406	November 23, 2023