# Convert Unix date to human-readable date
**URL:** https://forum.adalo.com/t/convert-unix-date-to-human-readable-date/2381
**Category:** Get Help
**Created:** [July 7, 2020, 7:17pm UTC](https://forum.adalo.com/t/convert-unix-date-to-human-readable-date/2381 "2020-07-07T19:17:12Z")
**Posts on this page:** 5
**Page:** 1
### Author:  [@vjragavan](https://forum.adalo.com/u/vjragavan)
#### Post date: [July 7, 2020, 7:17pm UTC](https://forum.adalo.com/t/convert-unix-date-to-human-readable-date/2381/1 "2020-07-07T19:17:12Z")
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?
---
### Author:  [@karimoo](https://forum.adalo.com/u/karimoo)
#### Post date: [July 7, 2020, 7:24pm UTC](https://forum.adalo.com/t/convert-unix-date-to-human-readable-date/2381/2 "2020-07-07T19:24:37Z")
@vjragavan Hi Vijay, have a look at [How to derive weekdays from a date](https://forum.adalo.com/t/how-to-derive-weekdays-from-a-date/2374) and [How to calculate with days and minutes](https://forum.adalo.com/t/how-to-calculate-with-days-and-minutes/2000). These give some background on how date and time are handled in Adalo.
---
### Author:  [@vjragavan](https://forum.adalo.com/u/vjragavan)
#### Post date: [July 7, 2020, 9:18pm UTC](https://forum.adalo.com/t/convert-unix-date-to-human-readable-date/2381/3 "2020-07-07T21:18:43Z")
@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 DateTime to Human readable format was available that would have been ideal.
---
### Author:  [@RynoHospitality](https://forum.adalo.com/u/RynoHospitality)
#### Post date: [July 8, 2020, 1:12am UTC](https://forum.adalo.com/t/convert-unix-date-to-human-readable-date/2381/4 "2020-07-08T01:12:56Z")
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!
---
### Author:  [@karimoo](https://forum.adalo.com/u/karimoo)
#### Post date: [July 8, 2020, 4:51am UTC](https://forum.adalo.com/t/convert-unix-date-to-human-readable-date/2381/5 "2020-07-08T04:51:13Z")
@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:
