I want to use the PDMLink created on date to automatically populate revision dates in our revision block. The problem is that if a new revision is created the date changes to the latest date. How can we make the date revision specific?
You can't. It will have to become either dumb text or be linked to a Creo parameter that does not change (containing dumb text).
You can capture the date in a revision specific parameter and use that in your revision block.
if revision == '1'
Revision1_date = EXTRACT(PTC_WM_CREATED_ON,1,10)
if revision == '2'
Revision2_date = EXTRACT(PTC_WM_CREATED_ON,1,10)
if Revision == '3'
Revision3_date = EXTRACT(PTC_WM_CREATED_ON,1,10)
Then use the &Revision#_date in your table for each revision.
Yes, we had something similar in our start parts.
We captured the initial created date and user initials.
You may want to use modified_on rather than created_on. Created _on does not change when you revise a part from 1 to rev 2.