Salesforce

WorldServer - What is the syntax in Freeform SQL to search for a date range?

« Go Back

Information

 
TitleWorldServer - What is the syntax in Freeform SQL to search for a date range?
URL Name000013006
SummaryYou have to put the date in curly braces for WorldServer to recognize that it’s a date and treat it accordingly.
Scope/EnvironmentWorldServer
Question
What is the syntax in Freeform SQL to search for a date range?  I've tried a lot of variations of this code, but to no avail:

[Created on] > '2020-01-01'
or
[Created on] < '2020-01-01'

Answer

Use:

[Created On] > {1/1/2020}

or

[Created On] < {1/1/2020}

You have to put the date in curly braces for WorldServer to recognize that it’s a date and treat it accordingly. another example:

[Created On] between  {2/16/21} and {2/20/21}

This article provides more information about how to use Freeform SQL:

WorldServer - How to use Freeform SQL in WorldServer to look up Translation Memory Units?

Reference
Attachment 1 
Attachment 2 
Attachment 3 
Attachment 4 
Attachment 5 

Powered by