You’re offline. This is a read only version of the page.
95
We need a list of all part numbers created in 2011 but when we look at the created date, it changes if the part was ever modified.
We also looks at the DEX_ROW_ID but since we don't know where the ID was at the end of the year, we can't tell when 2011 started.
We are using 10.0
Any ideas?
*This post is locked for comments
Both Created Date and modified date change every time you touch and modify the part number again.
Also, if you copy one part number from another part number, the created date is copied from the original.
Nothing in GP shows a true created data.
GP 2010 has both Created Date and Modified Date in IV00101. Your IV00101 table doesn't have both fields? I don't have a 10.0 database to look at.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,240
Super User 2024 Season 2
#2
Martin Dráb
230,149
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (