Archived from the Bravo community forum (2021–2026). Some answers may refer to older versions of Bravo.
I am currently working with an API from the Navitia tool. I need to know in real time the updated date and time to integrate it in my application.
The API provides the date data in ISO 8601 format. Displaying the date in this format to users of my application is unreadable. Do you know a solution to convert this format to European date (DDMMYYYY - HHMM)?
For example, the API provides : 20221105T084400
The goal is to convert in this format : 08:44 05/11/2022
The API can't be modified, maybe it is possible to convert through the JSON command ...
I thank you for your help in advance.
3 replies
On airtable you can divide lt eith RELFT and RIGHT formulas then join everithing by the order you what with, i think, concatenate formula.
As mentioned in the body of my post, this is a Navitia API, not Airtable.
Hello ! you will need to use a 3rd party to do that if your backend do not allow it. For example Maker (Integromat) or napkin.io could be an option.
Wrote something in this thread and want it removed? Request removal
Ask the community on Discord
This archive is read-only. New questions, office hours and product updates now happen in the Bravo Discord.
Join the Discord