Automate date selection criteria in MAS 200 export job

[nickerp]

I am trying to run a export job using VI command. I am trying to pull data from INVHISH table based on the INVOICE_DATE. I will run the job everyday. When I run the job today(10/16/2008) the job should return records with INVOICE_DATE 10/15/2008). I am pulling my hair for the past two weeks and this is an urgent requirement. Can someone please advice me. Thanks.

 

[BigLouie]

In the Export job, tab 4 Select, However this is hard coded meaning you would have to change it each day. LOTS easier would be to pull using Access.

 

[nickerp]

Thanks BigLouie. I tried that before posting on the forum. Thanks for your time.