Help

Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

From 2 digit year to 4 digit year

Topic Labels: Dates & Timezones
155 0
cancel
Showing results for 
Search instead for 
Did you mean: 

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