How to generate a DB for Customer and Vendor after extracting whole data from the DB

What should be the query for pulling the Master Data like Customer and Vendor after the first extraction was done. Let's say I run the query today 07/19/2018 and again on 07/31/2018 I want to extract only the Master Data from 07/20/2018. 

Whether below mentioned query will help.

Select * from RM00101 where CREATDDT >= '2018-07-19 00:00:00.000'

Thanks,

Chemp

Parents
No Data
Reply
  • Hi Chemp,

    If you goal is to identify those customers which have been created after a certain point in time, then yes using the script above which references the CREATDDT will work.  However, if you are also needing to identify changes "edits", then you will need to used the last modified date as well.

    Thanks much

Children
No Data
Related
Recommended