Not Changing text field to Date/TIme

[Shekhar Deshin1]

Hi,

We have this field Expiration date' (u_expiration_date) on custom table in String/Text format.
We are running Utha release instance however we are not able to change this String field to Date/Time in Dictionary entry for u_expiration_date,

Please suggest what is the reason that we are not getting Date/Time while search in Reference field.

Thanks,

Shekhar

[Dr Atul G- LNG]

Hi @Shekhar Deshin1 

Greetings!!

Are you changing at parent or extended table?

Also please note, if you change the data type it going to be impact to the existing data, so please take the back up. 

Also, better to hide the field and create new with new data type and populate the data from background.

https://www.servicenow.com/community/developer-forum/is-there-a-way-to-change-date-time-type-to-date...

[Shekhar Deshin1]

Hi,

This is Parent custom table.

for backend also we need to do lot of things to change string field to Date/Time field.

Please suggest any from ServiceNow side.

Thanks,

[Shekhar Deshin1]

We need to change this format from String field yyyy-MM-dd'T'HH:mm:ss.SSSZ to Normal Date/time 2023-03-22 17:49:57 for date/time field 24Hrs Format.

[Danish Bhairag2]

Hi @Shekhar Deshin1 ,

Please check this link

https://www.servicenow.com/community/developer-forum/need-to-change-type-of-a-field-from-string-to-r...

Thanks,

Danish