Concatenate two fields into a date

[StyleFinder_Roc]

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

[kuovonne]

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.