When I use now() I get the date and time in this format: 2/14/2023 11:05:35 AM To save space, is there a way to reformat the output to: 2/14/23 11:05 AM Many thanks! Gregg

No problem @Gregg_Stebben :blush: ! [image] Gregg_Stebben: Is there a way to get the year to output with two digits (23) vs 4 digits (2023)? Yes, but you would need to deconstruct/reconstruct the date according to the format you want :innocent: Format( "{1}/{2}/{3} {4}: {5}{6}", Today()…

Reformat date and time with now()

Jean_Pierre_Traets March 3, 2023, 3:01pm 9

Dear @Gregg_Stebben ,

Kind reminder where it was explained to you how to get the last two digit’s of the year

1 Like

Topic		Replies	Views
How can I change time formula's format?	2	1932	May 24, 2020
Display time in 24 hour format	5	1557	April 9, 2020
Calculate now()-date, including hours?	3	434	October 6, 2022
Need help creating a timestamp that doesn't change once entered like now() does	13	2615	May 25, 2022
Bug in hour() formula Bugs	7	461	November 4, 2022

Reformat date and time with now()

Related Topics