DataLoad Community

[COpfar]

Regardless of the number of responsibilities assigned to a user, is it possible to go to a specific responsibility assigned in order to change the "Effective From/To" date? What would the command look like in a macro load?

[ebelongia]

Hopefully you have figured out how to do this before now. The last time I did something like that, I had to query for the specific responsibility once in that part of the form.

In order to update all of the responsibilities, you would need to know how many responsibilities were present, then build your script to make that many updates. For that I would build the script in Excel and use a query to list the users and responsibilities. Put that list in two columns in Excel, then use simple if statements to note when the user changes (to re-query for the next user) and use the number of responsibility rows to set the effective date. It takes a little to set it up, but it should work.