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.
asked Feb 17, 2021 at 16:30
-
CreatedDate stores more than just the Date. It goes all the way down to milliseconds. Is your filter returning all records?– Daniel HoechstFeb 17, 2021 at 18:47
Add a comment
|
1 Answer
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)
answered Feb 17, 2021 at 18:49
-
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