Concatenating CreatedTime attribute and some Interval
Hi,I was windering if it is possible to concatenate the result of CreatedTime attributevalue with a certain period and write the end result to the EmployeeEndDate. Can that be done with a Function Evaluator Activity or do I need to have a custom activity?Example:CreatedTime = 6/25/2009 3:51:13 PMInterval = 1 yearEmployeeEndDate = CreatedTime + 1 year = 6/25/2009 3:51:13 PM + 1 Year = 6/25/2010 3:51:13 PMThanks!Cheers,Jorge [MVP-DS]Jorge de Almeida Pinto [MVP-DS / AD DS TechNet Forums Moderator]
October 7th, 2009 5:08pm
Hi Jorge! Unfortunately the Functions are way to limited for this (thats one of the reasons I've filed a feature request for custom functions at connect). In order to do this you probably have to do it using a custom workflow activity and the guys at Ensync has created one already that I believe does this but I'm not sure it works for RC1 but the source is included so you could probably fix it pretty easy... http://ilm2rc0enswf.codeplex.com/ Henrik Nilsson Blog: http://www.idmcrisis.com Company: Cortego (http://www.cortego.se)
October 7th, 2009 8:13pm
Hey Jorge,You can add time onto DateTime types in flow rules using <dateTimeAttr> + "T24:00:00.000", for example. So, if your HR source has a CreatedTime type attribute you can flow that, adding 8760 hours, to set your EndDate in an inbound flow rule, e.g.CreatedOn + "T8760:00:00.000" --> EmployeeEndDateAs for whether or not we can do this in the Function Evaluator I don't know, as I'm not in a position to test at the moment. Although Henrik is probably right, I'd be inclined to test it, as I've been pretty pleased with what I've been able to do quite quickly with the FE in RC1. My biggest problem is lack of documentation of this activity.
October 8th, 2009 10:20am