I made this a feature request, as it appears from Help documentation that it cannot currently be done.
I have dates in one table which are in a lookup field (so Assets in a table of assets find out their deadline from the deadline of the project in which theyโre included (Projects are in a separate table).
So I want to show the Assets in a Calendar view showing when they need to be done, but the date field for the calendar view isnโt a Date fieldโtechnically itโs a Lookup fieldโso it doesnโt show as an available date. If I copy the value from the Lookup field to a dummy Date field I run into the problem Y_K posted: that a Formula Field doesnโt work (either) for the purposes of the Calendar view.
Basically, Airtable users need to use any field formatted as Date as input for the Calendar View.
Thank you!! Airtable is miraculous. (And PLEASE donโt let anyone buy the company!)