When using DIFFINDAYS for a calculated date time field, a user is trying to compare two custom date time fields.
DIFFINDAYS(New_Customdate, new_customdate2)
It returns the error " You Can't set the value DIFFINDAYS(New_Customdate, new_customdate2) Which is a type of integer to type DateTime.
Same error if you use DIFFINDAYS(New_Customdate, NOW())
Returns: It returns the error " You Can't set the value DIFFINDAYS(New_Customdate, NOW()) Which is a type of integer to type DateTime.
But the following works:
DIFFINDAYS(createdon, NOW())
So that's a system field on the entity. Why will this not work using two custom date fields or a custom date field with NOW()?
*This post is locked for comments