The Community will be undergoing maintenance on Friday January 10 at 2:00pm - Saturday January 11 at 2:00pm EST, and will be "read-only." For assistance during this time, please visit our Help Center.

From 2 digit year to 4 digit year

posted May 17, 2022 4:30:50 PM

Topic Labels: Dates & Timezones

1 559 0

Hello, who can give an advice how to
22 to 2022
23 to 2023 etc…

I guess I can just concat “20” & MyDigits
maybe there is possible more elegant solution?

UPD: I Found solution with DATETIME_FORMAT(‘01/01/’&MyDigits, ‘YYYY’)

0 Replies 0