0

I have a report which has a filter contact: created date not equal to website inquiry: created date, however it is not working. I created a formula on the website object Contact__r.CreatedDate <> CreatedDate however it is not working. Could someone please assist me in figuring this out because For some reason, SFDC does not support comparisons between two fields.

1
  • CreatedDate stores more than just the Date. It goes all the way down to milliseconds. Is your filter returning all records? Feb 17, 2021 at 18:47

1 Answer 1

0

My guess is that the CreatedDate fields are never matching because they store the time part as well. If you just want to compare the date parts, try this in your formula:

DATEVALUE(Contact__r.CreatedDate) <> DATEVALUE(CreatedDate)

1
  • Hey Daniel, yeah my filter was returning all records. I will try this out and let you know how it works. Thanks very much Feb 17, 2021 at 20:01

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .