fix date format and datatype for lat lang