I have an airtable base with following fields:
Date - in airtable Europen date format
Date to send to ADalo - a text copy of the Date field
I did it like this, because in “Select” fields in Adalo, it does not pull data from Airtable Fields.
The issue is that now when I select a certain date to save, the database records a totally different field (my database field is in Date format) so data flow is from text in airtable to date in Adalo. I believe this is happening due to Adalo being in US date format?
How to overcome this, do we have a format formula?
Example, I made a saving as “30/10/2020” and date was recorded as “11/8/2020”