function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
jlimjlim 

Question: SOQL how to join Opportunity Close Date with Dated Conversion Rate?

I would like to accomplish this in 1 query. Is it possible? When selecting the Opportunity, I have the CloseDate and I would like to use this CloseDate and lookup in the DatedConversionRate table and get the exchange rate.

 

Thanks.

 

SelectedPartnerSelectedPartner

SOQL does not support all advanced features of the SQL SELECT command. For example, you cannot use
SOQL to perform arbitrary join operations, use wildcards in feld lists, or use calculation expressions.