Hi, I’m using open weather API data for a weather app. It is returning the Unix date_time which is the time elapsed since 1/1/1970. Is there a way in Adalo to convert it to a human-readable date format?

@karimoo , Thank you for linking them. Calculating the week of the day using modulo operation did not require finding what date that Unix-number corresponds to. Effectively, I want something like Convert_to_date ( returned-unix-datetime / 86500). If in the Date/Time calculation, Conversion of Unix…

You may be able to run the api call through zapier and have it format the data before sending to adalo. I know it’s an option in zapier!

@vjragavan The only current workaround would be to first store the (returned-unix-datetime / 86500) into a DateTime field in Adalo and then bring it onto the screen using the Date Picker formatting options: [image]

Convert Unix date to human-readable date

Get Help

karimoo July 7, 2020, 7:24pm 2

@vjragavan Hi Vijay, have a look at How to derive weekdays from a date and How to calculate with days and minutes. These give some background on how date and time are handled in Adalo.

Topic		Replies	Views
Sending date from Adalo to an API Get Help	5	1316	September 2, 2020
Converting numbers to dates for external connection fields External Collections, Custom Actions & Collections	1	1310	June 30, 2021
Date data type in Adalo External Collections, Custom Actions & Collections	4	1091	April 1, 2021
Can I convert unix time to a date in a custom formula? Get Help	1	1142	September 10, 2020
Date, Time & Time Zones Get Help	1	571	August 2, 2021

Convert Unix date to human-readable date

Related topics