DataLoad Community Forum Index DataLoad Community

 
 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

Change responsibilities 'Effective To' date assigned to user

 
Post new topic   Reply to topic    DataLoad Community Forum Index -> Macro Load Support (.dld files)
View previous topic :: View next topic  
Author Message
COpfar



Joined: 22 Jan 2010
Posts: 2

PostPosted: Mon Jan 13, 2014 4:20 am    Post subject: Change responsibilities 'Effective To' date assigned to user Reply with quote

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?
Back to top
View user's profile Send private message
ebelongia



Joined: 09 Jan 2015
Posts: 4

PostPosted: Fri Jan 09, 2015 6:30 pm    Post subject: Reply with quote

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.
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    DataLoad Community Forum Index -> Macro Load Support (.dld files) All times are GMT
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group