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?

D
DK_110859826-ContributorAuthor
6-Contributor
April 14, 2025

Hmm,

Yes, only year is gone wrong. Day and month is correct.

Around 2k records

 

Terms & ConditionsCookie settingsAccessibility statement