jorfasan Posted March 16, 2005 Posted March 16, 2005 Hi, I would like to know if it is posible to deconstruct a range of dates, just the opposite problem we have dealt before v7. In essence. I get from related Value list the following dates 14/7/2003 17/7/2003 18/7/2003 21/7/2003 22/7/2003 23/7/2003 24/7/2003 28/7/2003 29/7/2003 30/7/2003 Bu I need 14/7/2003, 14/7/2003, 17/7/2003, 18/7/2003, 21/7/2003, 24/7/2003, 28/7/2003, 30/7/2003, ranges in pairs in order to be sent for charting. I know how to make it with a go to related records & loop passing through the records sending data to a global an gettng the result. But for speed (
jorfasan Posted March 16, 2005 Author Posted March 16, 2005 Hi, I would like to know if it is posible to deconstruct a range of dates, just the opposite problem we have dealt before v7. In essence. I get from related Value list the following dates 14/7/2003 17/7/2003 18/7/2003 21/7/2003 22/7/2003 23/7/2003 24/7/2003 28/7/2003 29/7/2003 30/7/2003 Bu I need 14/7/2003, 14/7/2003, 17/7/2003, 18/7/2003, 21/7/2003, 24/7/2003, 28/7/2003, 30/7/2003, ranges in pairs in order to be sent for charting. I know how to make it with a go to related records & loop passing through the records sending data to a global an gettng the result. But for speed (
jorfasan Posted March 16, 2005 Author Posted March 16, 2005 Hi, I would like to know if it is posible to deconstruct a range of dates, just the opposite problem we have dealt before v7. In essence. I get from related Value list the following dates 14/7/2003 17/7/2003 18/7/2003 21/7/2003 22/7/2003 23/7/2003 24/7/2003 28/7/2003 29/7/2003 30/7/2003 Bu I need 14/7/2003, 14/7/2003, 17/7/2003, 18/7/2003, 21/7/2003, 24/7/2003, 28/7/2003, 30/7/2003, ranges in pairs in order to be sent for charting. I know how to make it with a go to related records & loop passing through the records sending data to a global an gettng the result. But for speed (
RalphL Posted March 16, 2005 Posted March 16, 2005 The list you show has a pilcrow (paragrahp mark) between the dates. Use the subsitute function to replace it with a comma. A value list will not contain duplicates. Try using the Troi Text Plug-in http://www.troi.com to make your list.
RalphL Posted March 16, 2005 Posted March 16, 2005 The list you show has a pilcrow (paragrahp mark) between the dates. Use the subsitute function to replace it with a comma. A value list will not contain duplicates. Try using the Troi Text Plug-in http://www.troi.com to make your list.
RalphL Posted March 16, 2005 Posted March 16, 2005 The list you show has a pilcrow (paragrahp mark) between the dates. Use the subsitute function to replace it with a comma. A value list will not contain duplicates. Try using the Troi Text Plug-in http://www.troi.com to make your list.
Recommended Posts
This topic is 7193 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now