Skip to main content
D
DK_110859826-Contributor
6-Contributor
April 14, 2025
Question

How to mass update the year for Created On date.

  • April 14, 2025
  • 1 reply
  • 970 views

Hi team,

How to mass amend/modify the year value for Created On date.

 

For Eg:

01-01-2050 to be modified to 01-01-2015

1 reply

avillanueva
23-Emerald I
avillanueva23-Emerald I
23-Emerald I
April 14, 2025

Best way to do this would be a SQL update. You didn't say what object they should all be similar. There is no mechanism in Windchill UI to change this but easy enough to do at DB level, and faster too.  Make sure you employ proper backup strategies before update.

D
DK_110859826-ContributorAuthor
6-Contributor
April 14, 2025

Hi Avillanueva,

 

Thanks for the reply.

Is it possible to touch only the year part of the date?

avillanueva
23-Emerald I
avillanueva23-Emerald I
23-Emerald I
April 14, 2025

No, you would need to extract the current date and time, modify it and translate into SQL update scripts to push it back in.  How many records do you have that are wrong?

Terms & ConditionsCookie settingsAccessibility statement