I would like to retrieve items in an old database after a date, export them to a file, and import them into a new database.
If this is possible, what would the query be?
Can the retrieved items then be exported to a csv file?
*This post is locked for comments
Please note that lastupdated is affected by sales, inventory processes and manual edits. This is not a date created timestamp field
select description,id,itemlookup,departmentid,lastupdated,categoryid,price,taxid,cost,quantity,barcodeformat,taxable,lastcost,datecreated from item where lastupdated > '6/2/2016'
#1
André Arnaud de Cal...
292,494
Super User 2025 Season 1
#2
Martin Dráb
231,305
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
