A Quick Guide to Using Date Functions in NocoDB

[@Hi-sc1dw]

Hi, is it possible to format date to "ddmmyyyy"?

[@nocodb]

Hey, you can use this formula -
CONCAT(SUBSTR({Date}, 9, 2), SUBSTR({Date}, 6, 2), SUBSTR({Date}, 1, 4))

[@Hi-sc1dw]

@@nocodb Thank you