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.

Re: Concatenate two fields into a date

39 0
Showing results for 
Search instead for 
Did you mean: 

Using the web clipper app, which doesn’t support the Date field. I can create a Month and Day field in the Clipper in which the user inputs the values. Can I then concatenate the Month and Day into Date type which results as an example 4/14/2022?

I appreciate any help. Cheers

1 Reply 1

Welcome to the Airtable community!

Yes you can. You will probably need to use DATETIME _PARSE() as well as concatenation, which are documented in the formula field reference. The exact details of the formula will depend on how you determine the year and how you concatenate the parts of the date.