Part Create Date

Yahoo Archive
1
Thanks Nancy.  This will work for some of our parts but unfortunately, we had to data merges happened in the last 4 years so most of the "new record' change logs will reflect when those parts were "migrated" into our main DB.  Nevertheless, this is a great way of getting the create date going forward.  Thanks again for your input.
2
Is there a way to find when a part was first created/saved in the system?  We are trying to include in a report and also in the Part Tracker.  Any help will be appreciated.  Thank you.


Progress 803.409C
3

I created a query that looks at the ChgLog and Part table and my criteria is ChgLog.LogText “matches”  “new”  and I can use ChgLog.DateStamp for date ranges.

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of juy@...
Sent: Thursday, March 13, 2014 10:13 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Part Create Date

 

 

Is there a way to find when a part was first created/saved in the system?  We are trying to include in a report and also in the Part Tracker.  Any help will be appreciated.  Thank you.

 

 

Progress 803.409C

4
Nope...unless you turned on change logs when you first started the system!

Manasa


On Thu, Mar 13, 2014 at 9:12 AM, <juy@...> wrote:

  
<div>
  
  
  <p>Is there a way to find when a part was first created/saved in the system? &nbsp;We are trying to include in a report and also in the Part Tracker. &nbsp;Any help will be appreciated. &nbsp;Thank you.<div><br></div><div><br><div>

Progress 803.409C

</div>
 


<div style="color:rgb(255,255,255);min-height:0px;"></div>

5

You could use the change log but, it is hard to query.

 

You could write a BPM to populate one of the user defined Date fields when the part is added to the database.

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of juy@...
Sent: Thursday, March 13, 2014 7:13 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Part Create Date

 

 

Is there a way to find when a part was first created/saved in the system?  We are trying to include in a report and also in the Part Tracker.  Any help will be appreciated.  Thank you.

 

 

Progress 803.409C