How to Populate a Date/Time Field on Incident Table Using External Data from Another Environment via
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-17-2025 09:31 AM
Hi community,
I have a field u_closed_incident (type: Date/Time) on the Incident table, and I want to populate it using data extracted from one environment and applied in a second environment. In the first environment, I exported incident numbers along with their actual close dates (from activity history), but in the second environment, those records exist without historical activity. I now want to write a fix script that reads a name-value pair (incident number + close date) from a custom table (e.g., incident) and updates the corresponding Incident records by setting u_closed_incident to the given date. What is the recommended approach to implement this using GlideRecord?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-18-2025 12:09 AM
Hi @DevYadav. Is there a reason you want to use a fix script? You could use a transform map and there is a field option available for date/time which will take care of it for you.