The use of ‘Subtract’ function is to get the difference between two numeric values. For example, when you run a query with ‘subtract’ function like below:
- SELECT subtract(2,1) FROM DUAL(), would give the result as ‘1’.
Regarding your question, if I need to query the records between two dates then I would use "addday" function in the VQL query as below:
- SELECT * FROM <VIEWNAME> WHERE CREATION_DATE BETWEEN addday(CURRENT_DATE(), -2) and CURRENT_DATE()
You can navigate to “Help > Functions list” of the Virtual DataPort Administration tool to know more about different data functions.
Hope this helps!!