Skip to main content
Gunjan Garg 님이 #SOQL Query에 질문했습니다

Opportunity object does not have close month, it has close date. So, how can i query it and fetch the record from Salseforce database. I am executing this query inside opportunity trigger.

  #trigger    #SOQL Query

Any help will be appriciated.

답변 4개
  1. 2021년 9월 7일 오후 12:26

    Hi Gunjan,

     

    Could you please use this query,

     

    select count(id) from Opportunity where CALENDAR_MONTH(CloseDate) = 9 AND StageName ='Closed Won'
0/9000