[U2] sorting by last mv
I am running UNIDATA and I am looking for help in creating a DICT item to determine the last mv value in an attribute. The attribute contains submit dates and are in ascending order. I need to sort a the file by the most recent submit date which is the last date in the attribute. I can get the first multi-value (date) with no trouble but I need the LAST muti-value date. Is my only option to call a subroutine? Christine Callahan Callahan Associates 941-778-0823 [EMAIL PROTECTED] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] sorting by last mv
@RECORDattribute, DCOUNT(@RECORDattribute,@VM) -Original Message- From: c callahan [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 06, 2007 4:41 PM To: u2-users@listserver.u2ug.org Subject: [U2] sorting by last mv I am running UNIDATA and I am looking for help in creating a DICT item to determine the last mv value in an attribute. The attribute contains submit dates and are in ascending order. I need to sort a the file by the most recent submit date which is the last date in the attribute. I can get the first multi-value (date) with no trouble but I need the LAST muti-value date. Is my only option to call a subroutine? Christine Callahan Callahan Associates 941-778-0823 [EMAIL PROTECTED] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] sorting by last mv
Christine, on Universe you can set up an Itype @RECORDfield,DCOUNT(@RECORDfield,@VM) jak - Original Message - From: c callahan [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Wednesday, November 07, 2007 9:41 AM Subject: [U2] sorting by last mv I am running UNIDATA and I am looking for help in creating a DICT item to determine the last mv value in an attribute. The attribute contains submit dates and are in ascending order. I need to sort a the file by the most recent submit date which is the last date in the attribute. I can get the first multi-value (date) with no trouble but I need the LAST muti-value date. Is my only option to call a subroutine? Christine Callahan Callahan Associates 941-778-0823 [EMAIL PROTECTED] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] sorting by last mv
DCOUNT(Dict_Name, @VM) ; EXTRACT(Dict_Name, 1, @, 1) David A. Green www.dagconsulting.com (480) 813-1725 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of c callahan Sent: Tuesday, November 06, 2007 3:41 PM To: u2-users@listserver.u2ug.org Subject: [U2] sorting by last mv I am running UNIDATA and I am looking for help in creating a DICT item to determine the last mv value in an attribute. The attribute contains submit dates and are in ascending order. I need to sort a the file by the most recent submit date which is the last date in the attribute. I can get the first multi-value (date) with no trouble but I need the LAST muti-value date. Is my only option to call a subroutine? Christine Callahan Callahan Associates 941-778-0823 [EMAIL PROTECTED] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] sorting by last mv
Does this work for UniData? I was thinking you can only: EXTRACT( ACCTS, 1, 0, 0 ) ; EXTRACT( @1, 1, DCOUNT( @1, @VM ), 0 ) ...or use @RECORDn for ACCTS. Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of John Kent Sent: Tuesday, November 06, 2007 3:18 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] sorting by last mv Christine, on Universe you can set up an Itype @RECORDfield,DCOUNT(@RECORDfield,@VM) jak - Original Message - From: c callahan [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Wednesday, November 07, 2007 9:41 AM Subject: [U2] sorting by last mv I am running UNIDATA and I am looking for help in creating a DICT item to determine the last mv value in an attribute. [snipped] Christine Callahan Callahan Associates 941-778-0823 [EMAIL PROTECTED] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/