topic Salesforce SQL select not in future in QlikView

Salesforce SQL select not in future

Fri, 16 Jan 2015 13:45:40 GMT

Hi all,

i am trying to ensure no scheduled Salesforce Activities in the future are loaded, but my WHERE clause doesn't seem to be correct. What am I doing wrong?

Activities:

LOAD Id AS ActivityId,

'eCommerce' AS ActivityOrg,

Subject,

ActivityDate AS CalendarDate,

OwnerId,

Description AS eCommercePublicNotes,

Type;

SQL SELECT *

FROM Task

WHERE ActivityDate <= Today();

Re: Salesforce SQL select not in future

Gysbert_Wassenaar — Fri, 16 Jan 2015 13:51:12 GMT

Today() is a qlikview function. You can't use qlikview functions in SQL statements since those are processed by the dbms and not by qlikview. According to SalesForce.com SOQL and SOSL Reference you can use TODAY instead.

Date Literals

A fieldExpressioncan use a date literal to compare a range of values to the value in adateordateTimefield. Each literal is a range of time beginning with midnight (12:00:00). To find a value within the range, use=. To find values on either side of the range, use>or<. The following table shows the available list of date literals, the ranges they represent, and examples:

Date Literal	Range	Example
`YESTERDAY`	Starts 12:00:00 the day before and continues for 24 hours.	`SELECT Id FROM Account WHERE CreatedDate = YESTERDAY`
`TODAY`	Starts 12:00:00 of the current day and continues for 24 hours.	`SELECT Id FROM Account WHERE CreatedDate > TODAY`

Re: Salesforce SQL select not in future

Anonymous — Fri, 16 Jan 2015 13:58:11 GMT

I don't think you can use Today() in a SQL SELECT query. Try something like:

WHERE ActivityDate = #" & format(Date,"mm/dd/yyyy") & "#"