Tableau CRM SAQL Developer Guide
jNewer Version Available
Time Zone Date Functions (Beta)
In SAQL, the DateOnly type displays the date with an empty timestamp, for example, “2014-12-31 00:00:00.” The inclusion of the timestamp is a limitation of the beta release.
Note
As a beta feature, Single Custom Time Zone is a preview and isn’t part of the “Services” under your master subscription agreement with Salesforce. Use this feature at your sole discretion, and make your purchase decisions only on the basis of generally available products and features. Salesforce doesn’t guarantee general availability of this feature within any particular time frame or at all, and we can discontinue it at any time. This feature is for evaluation purposes only, not for production use. It’s offered as is and isn’t supported, and Salesforce has no liability for any harm or damage arising out of or in connection with it. All restrictions, Salesforce reservation of rights, obligations concerning the Services, and terms for related Non-Salesforce Applications and Content apply equally to your use of this feature. You can provide feedback and suggestions for Single Custom Time Zone in the Trailblazer Community.
Note
-
Use Time Zone-Enabled Dates in SAQL Projections
You can project an exact date such as 2017-3-31 23:59:59 or part of a date such as year, month, or day. -
Access Date Functions with Time Zone Enabled
Use these functions to get the day, week, year, and other parts of DateTime or DateOnly fields. The return values are numbers. -
Group By Date
You can group the result of your SAQL query by DateTime and DateOnly fields. -
Order By Date
You can order the result of your SAQL queries by DateTime or DateOnly. -
Filter By Date
You can filter results by DateTime and DateOnly fields. Filters can include exact dates, specific date ranges, or relative date ranges. -
Calculate the Time Between Two Dates
Use date_diff() and daysBetween() to calculate the time between two dates. -
Convert Dates to and from Strings
You can convert dates to strings. -
Handle Null Dates
Use is not null to filter out null dates. -
Determine the Day in the Week, Month, Quarter, or Year
These functions return the day of the week, month, quarter, or year, the date of the last day of the week, month, quarter, or year, and the number of days in the quarter or year.