Date Functions

[reesesm]

Does anyone know if it is possible to use any of the CALENDAR_ functions available in the SOQL spec? I need to do the following

SELECT CALENDAR_YEAR(CloseDate), SUM(Amount)
FROM Opportunity
GROUP BY CALENDAR_YEAR(CloseDate)

To basically get a sum of all the amounts per year. Searched through the forum but cannot find any reference to these functions. They seem pretty useful to me and I would be surprised nobody else would need to do something similar. Below are the functions supported by SF on date

CALENDAR_MONTH()
CALENDAR_QUARTER()
CALENDAR_YEAR()
DAY_IN_MONTH()
DAY_IN_WEEK()
DAY_IN_YEAR()
DAY_ONLY()
FISCAL_MONTH()
FISCAL_QUARTER()
FISCAL_YEAR()
HOUR_IN_DAY()
WEEK_IN_MONTH()
WEEK_IN_YEAR()

[Shalex]

dotConnect for Salesforce executes SQL statements, that are SQL-92 standard compliant: http://www.devart.com/dotconnect/salesf ... ement.html.

We will investigate the possibility of supporting different SOQL functions via interface of our provider and notify you about the result. Thank you for your suggestion.

[reesesm]

Hi Shalex

Is there any movement on this? We have a customer who really needs to do things with dates and years and months etc.

Regards

Sean

[Shalex]

The investigation is in progress. We will provide a timeframe for this feature (or notify you about its implementation) this Thursday.

[Shalex]

This feature is on our roadmap for the next public build (approximate timeframe is two weeks).

[reesesm]

That is great news. Thanks Shalex.

[Shalex]

The new build of dotConnect for Salesforce 2.4.628 is available for download now: http://forums.devart.com/viewtopic.php?f=38&t=31737. Please try it and notify us about the result.