=date(left(A1,4),mid(A1,5,2),right(A1,2)) Or, take the leftmost four characters as the year, the rightmost two characters as the day, and two characters in the middle starting at position 5 as the month, and convert it to a date. Perhaps add a Formatter action to convert the date from 05:53:24 PST to an easier-to-read format like Wednesday, June 1st, 2016.appsheet change date format Date: The converted value if when is recognized as a Date, DateTime, or Time value, or blank if not.
