[U2] [UD] Building a Dictionary with MV Functions

2011-02-08 Thread Bill Haskett
I have a record that monitors when users have last requested a banking process. In the record I have: 00n Date]Date]...]Date n+1 Time]Time]...]Time n+2 User]User]...]User I want to know who's requested the process within the last half hour (a half hour being 1,800 seconds). The

Re: [U2] [UD] Building a Dictionary with MV Functions

2011-02-08 Thread Buss, Troy (Logitek Systems)
-users-boun...@listserver.u2ug.org] On Behalf Of Bill Haskett Sent: Tuesday, February 08, 2011 9:43 AM To: U2 Mail List Subject: [U2] [UD] Building a Dictionary with MV Functions I have a record that monitors when users have last requested a banking process. In the record I have: 00n Date]Date

Re: [U2] [UD] Building a Dictionary with MV Functions

2011-02-08 Thread Bill Haskett
, February 08, 2011 9:43 AM To: U2 Mail List Subject: [U2] [UD] Building a Dictionary with MV Functions I have a record that monitors when users have last requested a banking process. In the record I have: 00n Date]Date]...]Date n+1 Time]Time]...]Time n+2 User]User]...]User I want to know

Re: [U2] [UD] Building a Dictionary with MV Functions

2011-02-08 Thread Tony Gravagno
From: Troy Buss LIST ECN F112 F113 EVAL \(REUSE(@DATE * 86400 + @TIME)) - ((F112 * REUSE(86400)) + F113)\ AS X FMT 14R CONV WITH X = 10800 I may lead a sheltered life, but that is the coolest, most elegant use of EVAL that I have seen in a Long time. It's simultaneously a perfect example