function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
dzshannodzshanno 

Why is ~~~ used in SAQL queries rather than -?

I've seen ~~~ in many example SAQL queries but not sure why you cant just use <space>-<space>? It seemsCan someone point me to some reference material? Thanks
AnudeepAnudeep (Salesforce Developers) 
Not sure about the reasoning but ' ~~~' is used for date fields. 

Example: 
q = foreach q generate 'Visit_Year' + "~~~" + 'Visit_Month' as 'Visit_Year~~~Visit_Month', Tourists;
Guess it is used to combine individual date fields to one field in saql

See Analytics SAQL Reference