Is there a way to change DATE/TIME type to DATE type in system dictionary?

[Vimal Priya]

Hi All,

I have created 19 fields in DATE/TIME data type in custom table .We are looking to change the DATE/TIME to simple DATE type . but I am unable to change as reference to Glide Object table does not showing Date option .

Is there a way to change DATE/TIME type to DATE type in system dictionary?

Please suggest.

[Ankur Bawiskar · Accepted solution]

Hi VimalPriya,

If there is data in those records with Date/Time and you want to make it Date there will be a data loss.

I think Date can be made as Date/Time but not the reverse.

Mark Correct if this solves your issue and also hit Like and Helpful if you find my response worthy based on the impact.

Thanks

Ankur

[Raghu Loganatha]

VimalPriya,

No!! You cannot change "Date/Time" type field to "Date". Luckily if you are still in Non-Production under development stage, i strongly recommend you to delete those fields and create a new "Date" type fields.

Please mark "Answered" or "Helpful" If this helps you resolve your issue.

[Prateek kumar]

Hello Vimalpriya

As the experts already said in this thread. I had a similar issue in the past.

Since you have only 18 records in the table. Create a new Date field and use a background script to copy all the old DateTime field values into your new Date field

[Vimal Priya]

Hi all,

Thanks for your responses .

Absolutely Date/time cannot be changed as Date .