VI Exports won't execute perform logic, so you would have to put it in a file like it is shown in the post.
https://www.sagecity.com/us/sage100_erp/f/sage-100-business-object-interface/170144/in-visual-integrator-is-there-a-way-to-select-records-within-a-number-of-days/435982#435982Alternatively, you could use a temp field as shown below. Using the temp field approach eliminates the need for a separate file to be maintained that contains the logic.
The following three must be configured exactly as seen below.
The calculation will vary depending on each job's criteria. In the example above, I used the following.
""; selected=TBL(POS(UCS("D1000")=UCS(CI_Item01.ItemCode$))<>0,isFalse,isTrue)
It first assigns an empty string to the temp field because the temp field's only purpose is so we can execute the next command which assigns a boolean value to the "selected" variable that the export evaluates on each record before writing it to the file. In the example above, it will only export items where the item code contains "D1000".
For you case, you would need to substitute the "CI_Item01.ItemCode$" field with your field from the export's available columns, make sure to get the correct numeric table suffix. If your job uses SO_SalesOrderHeader as the main table, then it should be SO_SalesOrderHeader01, if it uses SO_SalesOrderDetail, then the header will have a different number, see below for what this refers to.
Once you have the correct table and field variable, you need to create the evaluation used in the TBL function. The TBL function works a couple different ways but in this case, we are using it to evaluate our criteria and return either true or false (the contents in the isTrue and isFalse variables). To use the current date against the order date, it would look something like this. As mentioned above, change the numeric table suffix accordingly based on what is displayed in list of available fields.
""; selected=TBL(SO_SalesOrderHeader01.OrderDate$=DTE(0,"%Y%Mz%Dz"),isFalse,isTrue)
------------------------------
David Speck II
Tennessee Software Solutions
------------------------------