February 13, 2015 Leave a comment
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