Concatenate two fields into a date

Topic Labels: Formulas
694 1
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

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.