[ Home | TOC | Search | Post | Reply | Next | Previous | Up ]
Remote Name: 220.127.116.11
Date: 14 Aug 2001
I am new to this and I have to extract data out of the Advanced revelation (V3.0) database on a regaular basis.
I have created a saved script (probably not the correct term) so all I have to do is press F5 and type the key word, and it will run away are select specific data. Also have created a pretermined export to ASCII format, which i have saved, and once this initial select is run, I just type the name of this and it exports.
The question that I have is : Is it possible to have:
The select statement pull back records with a date that is that same as the system date?? (eg Date#=#Now()) Also to have this automated, so that it will run on a daily basis without manual input??
Sorry for the longwinded explaination, however I hope someone can instill a little faith with this, and help me out.
Thanks for your efforts in advance Rgds Troy