+ Start a Discussion

Date filters issue(help me please)



     how to retrieve the data dynamically when salesforce date field is lessthan or equal to dynamic field date. i used filters this way field(date)  operator (less than or equal) source(fixed value) value(static value(12(dd)/10(mm)/2012)). but we display automatically compare the date in filter criteria not static.


      how to compare date field in filters 



Steven LawranceSteven Lawrance

It may depend on where the dynamic date is coming from. In more complex cases, you may need to perform this evaluation in a custom formula field and then filter on the output of that custom formula field's value.