Salesforce Stack Exchange is a question and answer site for Salesforce administrators, implementation experts, developers and anybody in-between. It only takes a minute to sign up.
Sign up to join this community
Trying filter the data based on relative dates for which I dont find a solution . Instead creating a compute expression and then filtering based on the expressin value .
Tried the following in filter conditon which didn't work.
contract_Start_Date__c:R:this_month:next_n_months:3
then tried the following in compute expression which didn't work.
case when contract_Start_Date__c>=this_month and
contract_Start_Date__c<=next_n_months:3 then "true"
else "false" end
Relative date filters in SAQL are different from the ones in SOQL. Your compute expression should be this instead:
case when date('contract_Start_Date__c_Year', 'contract_Start_Date__c_Month', 'contract_Start_Date__c_Day') in ["current month".."3 months ahead"] then "true"
else "false" end
I don't believe the filter expressions work with relative dates.
