Hi,

Please bear with me, as I have a very low level of knowledge with A-Rev.

I am using a database which has been setup and has been in use for some time now. I am wanting to retreive data based on a certain date. In the TCL prompt I can type:

LIST JOBS WITH DATE=TODAY

'Today' will bring back the current date. I can also do tommorrow and yesterday - bringing back the current date + or minus one day.

My question relates to these 3 words. Are these setup in the system as default or would someone had to have created these to be able to use these as key words?? If they are 'user created', how can I view the code behind them, so that I can manipulate these to something like 'LAST WEEK' OR 'LAST MONTH' OR 'LAST YEAR' for example.

Sorry about the length, but I hope someone can assist here.

Thanks and Regards

Troy

SORT ONLY DICT.VOC WITH TYPE "RLIST" JUSTLEN 30

will list all the words available. EDIT DICT.VOC xxx, where xxx is one of the items in the list, and you will see as much as you can about the item, which is just a token for use by the RLIST processor.

Symbolic fields will work as well.

You can also define your own symbolics in DICT.VOC. RLIST will first look at the dictionary of the file your are querying against. If the dict item is not found in that dictionary, it will look in DICT.VOC.

Today, Tommorrow & Yesterday are system words.

You can create your own though. Just create them in the dictionary of the file you are using.

eg: from TCL type DICT JOBS LAST_WEEK

Create a symbolic (dict type S) with the formula being something like

@ANS=DATE() -7

Make sure to set the output format to D

Thanks heaps for the responses. Brilliant…my select now works, with the addition of the LAST_WEEK dict item….

You have made my day!!

Thanks again.

Rgds

Troy

View this thread on the forum...