How to use IIF and CustomExpression asking for current-dateTime (Today)
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
November 21st, 2010 2:08pm
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
Free Windows Admin Tool Kit Click here and download it now
November 21st, 2010 3:24pm
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?
November 21st, 2010 7:53pm
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
Free Windows Admin Tool Kit Click here and download it now
November 21st, 2010 10:44pm
Thanks Brian! It is good to know what is the right way to go!
November 22nd, 2010 6:01am
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!
Free Windows Admin Tool Kit Click here and download it now
May 15th, 2012 3:22am