Rule Date Comparisons in Rules Engine

That makes sense Kristin and I have encountered that too.

Gainsight Team -

Any thoughts on this? It continues to be quite confusing when rules don't work because the Created Date operator is "Equals", and the field value is a date/time stamp. Then I have to remember to make it "Greater or Equal to". All other date fields in Salesforce work using an "equal to" operator when comparing date values. Being consistent within the FORCE platform is important for administration.

thanks
Kristin

Hi Kristin,

Thanks for bringing this up, Let me explain you how RuleDate works, When we compare RuleDate against 'DateTime' field it will be compared as 'timestamp' where as if we do it against 'Date' field then it will compared as just Date.
So in your context, In Rule1 while adding Customers into the Customer Repository, try to load RuleDate into any 'Date' field. (Note: CreatedDate is a DateTime field, so not useful in this case).
If you don't have any 'Date' field then create one in customerInfo Object or somewhere else.
In Rule2 you can use the above Date field against Rule Date.

In Rules -> Setup Rule -> left hand side field listing, if you mouse over on a field then tool tip shows you which datatype it is.

Hope this helps you, please reply for any clarifications.

Thanks
Murthy Kavali

Kristin,

You can use a Formula field(Date filed) to convert DateTime to date and achieve this

your_new_date_field_formula = DATEVALUE(CreatedDate)

Use this new date field in Rule filter.

Let me know if this helps

Thanks for the explanations. Just seems like extra work for the Admin, and creation of extra fields, when the system should just take care of doing the date comparison. I don't believe there is a field type distinction when working in the Sales Cloud application. Date comparisons are done on just the date regardless if the field being compared to is a date/time field.

thanks
Kristin

Hi Kristin,

We are introducing formula functions within Rules Engine for fall release. One of the formula is to convert Datetime to Date field within Rules Engine itself. I believe this will simplify things further. I will keep you posted on this.

Thank you,
Jitin

Hi Kristin,

You can use the Date() function in the transformation task of Bionic Rules which will convert Datetime to Date value.

Regards,
Jitin