How to Convert Date/time type filed to Date type field?

[Shantharao]

Hi All,

I have a date/time type filed on the production and the client wants to be converted to a date-type field instead of a date/time
Already legacy records are populated with date/time stamp values, we are not able to see the date conversion in the dictionary entry,
When I make empty on the date field in the old records, I can see the date type in the dictionary 
But I don't want to lose old dates and want to change the type from Date/time to Date 
How can we do this without data loss? 
Thanks

[Prince Arora]

@Shantharao 

Export all the data first, make all the dates empty, update the data type to date and then upload the sheet again.

You can give it a try in PDI first and then go ahead with prod instance.

[Dr Atul G- LNG]

Hi @Shantharao 

There is no direct way to do this part like copy and replace , as you are changing at schema level. So what i can suggest

either keep the old data as it is and for new follow the new format and if still want to update

Take back up of all data

Change the data type

Upload the data ( in pieces, so that verification will be easy)