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

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!

No. This is NOT the way to go. The proper way is to nag M$ until they provide a set of Date() functions callable from a Sync Rule. It is beyond belief that an Inbound HR Feeding Sync Rule in FIM 2010 R2 cannot set the description string to "Disabled dd.mm.yyyy" where dd.mm.yyyy is the formatted string form of the current Date() when status is "Terminated" Please remember that some Sync Rules are NOT kicked off by MPR/SET/WORKFLOW, they are called when in Scope and the scope is set on the Rule itself with R2!