This article assumes that the user is already familiar with using Enterprise ad-hoc with input data node as detailed in the linked article and specifically covers the syntax for using this node with " between" operator. 

PREREQUISITES
Existing Ad-hoc analysis configuration
 

How to use the "between" operator in Enterprise Ad-hoc with input Node?

OPTION 1:

Enter the dates/input directly in the SQL Criteria with the format : AND=>[Query Name]=>[Field Name]=>[Date1/Input1] AND [Date2/Input2]=> between. For example :


OPTION 2:

If the input needs to be from the spreadsheet upstream of the node, then download the attached .svx file and place it in : [Statistica Install Folder]\DataMiner. Note that for existing workspaces, this node may have to be re-added. If you have existing SQL criteria that needs to be copied over, it is advised that you re-add the new node and copy SQL criteria and then delete the existing node.

Alternatively, you may copy the content of the svx file and then right click on the Enterprise Ad-hoc with Input data node and select Edit code. Replace the code with the one from the attached svx file. Note that choosing this way will make the between operator work with input spreadsheets only for this specific node in this specific workspace. 

After the file has been replaced, the standard spreadsheet format node may be used again to lookup values from the input spreadsheet. See example below :




 

https://support.tibco.com/s/article/How-to-use-Enterprise-Adhoc-Analysis-with-Input-data-node