https://communities.sas.com/t5/SAS-Programming/best-practice-for-daily-query-fetch-date/m-p/363164#M274868 <P>hi,</P><P>&nbsp;</P><P>I'm setting up daily automated reporting. Each morning, the job is set to query our tables for date: two days minus today (there is a two-day lag with the table refresh). &nbsp;An approach is to write: where table_date=today()-2;.</P><P>&nbsp;</P><P>If there is a better way (or if the above should be avoided), pls let me know. Currenly engine we use is Netezza, or Hadoop.</P><P>&nbsp;</P><P>thank you&nbsp;</P> Wed, 31 May 2017 17:29:12 GMT brulard 2017-05-31T17:29:12Z https://communities.sas.com/t5/SAS-Programming/best-practice-for-daily-query-fetch-date/m-p/363164#M274868 <P>hi,</P><P>&nbsp;</P><P>I'm setting up daily automated reporting. Each morning, the job is set to query our tables for date: two days minus today (there is a two-day lag with the table refresh). &nbsp;An approach is to write: where table_date=today()-2;.</P><P>&nbsp;</P><P>If there is a better way (or if the above should be avoided), pls let me know. Currenly engine we use is Netezza, or Hadoop.</P><P>&nbsp;</P><P>thank you&nbsp;</P> Wed, 31 May 2017 17:29:12 GMT https://communities.sas.com/t5/SAS-Programming/best-practice-for-daily-query-fetch-date/m-p/363164#M274868 brulard 2017-05-31T17:29:12Z https://communities.sas.com/t5/SAS-Programming/best-practice-for-daily-query-fetch-date/m-p/363184#M274869 <P>I might be better if done in netezza as where table_date=current_date-2 and create a work sas table and then run the report on it</P> Wed, 31 May 2017 18:45:04 GMT https://communities.sas.com/t5/SAS-Programming/best-practice-for-daily-query-fetch-date/m-p/363184#M274869 kiranv_ 2017-05-31T18:45:04Z