Concatenate two fields into a date

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

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.

1 Like

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.