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.

Short Date in Formula

Topic Labels: Formulas
Solved
Jump to Solution
759 1
cancel
Showing results for 
Search instead for 
Did you mean: 

Hi so I’m trying to write a formula to concatenate a name and a date but the date keeps coming back in long format. Is there anyway I can just have the short date (i.e. 09/05/2019) shown?

image.png

1 Solution

Accepted Solutions

Hi @Jess_Harlee - when you concatenate the date with something else you turn it into a string and the default format is the full YYYY-MM-DD HH:MM:SS:000Z. You need to format the DATE field using DATETIME_FORMAT()

Screenshot 2019-09-05 at 21.22.32.png

'Some text ' & DATETIME_FORMAT(Date, 'MM-DD-YYYY')

JB

See Solution in Thread

1 Reply 1

Hi @Jess_Harlee - when you concatenate the date with something else you turn it into a string and the default format is the full YYYY-MM-DD HH:MM:SS:000Z. You need to format the DATE field using DATETIME_FORMAT()

Screenshot 2019-09-05 at 21.22.32.png

'Some text ' & DATETIME_FORMAT(Date, 'MM-DD-YYYY')

JB