Time zone for Force.com API fiscal date literals?

Posted by Nick on Stack Overflow See other posts from Stack Overflow or by Nick
Published on 2010-03-26T08:34:09Z Indexed on 2010/04/13 20:33 UTC
Read the original article Hit count: 428

I have a question about fiscal date literals in the Force.com API (http://www.salesforce.com/us/developer/docs/api/Content/sforce_api_calls_soql_select_dateformats.htm):

For which time zone are date ranges calculated?

For example, suppose we execute the query:

SELECT Id FROM Opportunity WHERE CloseDate = THIS_FISCAL_QUARTER

where, according to our company's fiscal settings, THIS_FISCAL_QUARTER runs from Jan 1 to Mar 31.

Does the range for THIS_FISCAL_QUARTER use...

  • the user's time zone? For example, if the user's time zone is GMT-8, THIS_FISCAL_QUARTER = Jan 1 00:00 GMT-8 to Mar 31 23:59 GMT-8 (or Jan 1 08:00 UTC to Mar 31 07:59 UTC)
  • the company's default time zone (according to the company profile)? For example, if the company's default time zone is GMT-8, THIS_FISCAL_QUARTER = Jan 1 00:00 GMT-8 to Mar 31 23:59 GMT-8 (or Jan 1 08:00 UTC to Mar 31 07:59 UTC)
  • UTC? THIS_FISCAL_QUARTER = Jan 1 00:00 UTC to Mar 31 23:59 UTC
  • something else?

© Stack Overflow or respective owner

Related posts about force.com

Related posts about salesforce