Custom expression function in sync rule doesn’t return NULL

Some days ago I faced a problem at a customer site with datetime attribute flows.
Users have separation dates as long as they have a limited contract, but when they got an unlimited contract the separation date is removed (NULL in database).

I’ve got a response from a system owner that dates for users with unlimited contract will not be cleared in their system.
First thought was I may be forgot to set the “allow Null on export” flag. But it was set on that attribute which is exported as a string value.

My sync rules custom expression was like this:

DateTimeFormat(SeparationDate,"yyyy-MM-dd") => ContractEndDate

Advertisement