Hi: I'm configuring HR Inbound Sync Rule. The HR Database has a field called EndEmployeeDate I need to configure several Attributes flow based on this EndEmployeeDate. One Attribute in FIM and AD is EmployeeStatus. If EndEmployeeDate > Today, then EmployeeStatus should be set as ACTIVE If EndEmployeeDate < Today, then EmployeeStatus should be set as INACTIVE I did not find any function or CustomExpression to Compare EndEmployeeDate with Current Date (Today). can anybody help me with the syntax for this IIF, please Thanks in advance

What I would do is store that field in the EmployeeEndDate field in the portal and then define a pair of sets - one for active folks (date < today) and inactive (date > today). Create workflows using the Function Evaluator Activity to stamp ACTIVE and INACTIVE, and then create a pair of MPRs which fire those workflows when folks transition into the two sets.My Book - Active Directory, 4th Edition My Blog - www.briandesmond.com

What I would do is store that field in the EmployeeEndDate field in the portal and then define a pair of sets - one for active folks (date < today) and inactive (date > today). Create workflows using the Function Evaluator Activity to stamp ACTIVE and INACTIVE, and then create a pair of MPRs which fire those workflows when folks transition into the two sets.My Book - Active Directory, 4th Edition My Blog - www.briandesmond.com

Thanks Brian for your answer. I'll be working in your recommendation. I expected a solution directly in the Synchronization Rule, using the IIF and current-dateTime() function in a customexpression in Flow Definition. But the the answer is "The function named current-dateTime() could not be located" My question is: are customexpression so limited?

Thanks Brian for your answer. I'll be working in your recommendation. I expected a solution directly in the Synchronization Rule, using the IIF and current-dateTime() function in a customexpression in Flow Definition. But the the answer is "The function named current-dateTime() could not be located" My question is: are customexpression so limited?

Yes they're more or less listed to the functions displayed on the page. What you're trying to do isn't supported.My Book - Active Directory, 4th Edition My Blog - www.briandesmond.com

Thanks Brian! It is good to know what is the right way to go!

Thanks Brian! It is good to know what is the right way to go!