Forum Discussion
Filter what data is imported by date
Hello all, I have a progress database connected via ODBC. I have a large table called diary with many rows and I want to speed up the time it takes to refresh this table. I have searched high and low...
Hi Anonymous ,
It seems that you want to import the data with date filter to get the most important data rather than all of the data.
If so, you could enter the SQL Statement to select the data with date condition when you get data via ODBC like below.
Please refer to this similar thread.
Best Regards,
Cherry
HI v-piga-msft thanks for the response. I have zero knowledge of SQL: statements so wouldn't mind some help building what I need. how do I definae the table name, then the row and then specifiy the fact I only want stuff from current month and future dates?
thanks
don't worry I worked it out. thanks for pointing me in the right direction v-piga-msft