changing data type in order to add the formated date into the solidata table