Are you sure you want to do that? The problem with “%$DATE$%” is that keywords won’t resolve if imbedded within quotes like you’ve shown, but that’s not the only issue. (in another application, you’d use “%” + $DATE$ + “%” instead).
Entries in diary fields are timestamped in the format: Thursday, April 14, 2011 3:35:18 PM demo Internally, date/time is stored as EPOC time (number of seconds since 1/1/1970). I’m not sure it wouldn’t treat $DATE$ as unconverted (i.e. it may use mm/dd/yyyy 00:00:00). You could work around this by setting an integer field before your Set Fields and using it in your Set Fields If instead of $DATE$, but again, I’m not sure you want to. Theoretically an entry would need to have been made at the exact. Entries in a diary field aren’t separate rows/records. I imagine it would return the entire contents of the diary field, and you probably wouldn’t want what you got. Mike White EMail michael.wh...@verizon.com<mailto:michael.wh...@verizon.com> Office 813.978.2192 From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Ddussie Sent: Thursday, April 14, 2011 2:44 PM To: arslist@ARSLIST.ORG Subject: Re: Using Active link to bring data from another form. ** Any hints?... Please Sincerely, D.Dussie On Apr 14, 2011, at 1:23 PM, Ddussie <ddus...@aim.com<mailto:ddus...@aim.com>> wrote: Hello List, What am I doing incorrectly? ActiveLink Associated Form: Form1 Execute on button Runif Qualification null SetFields Datasource: Server ServerName: test Form Name: From2 Qualification: (Fields1.form2 LIKE "%$DATE$%") ; note Fields1.form2 is a diary field Set the following field to Field1.Form1 = $Status$ This is failing because the embedded qualification cannot translate $DATE$. However, if in form2 in the wut, you execute the command Fields1.form2 LIKE "%$DATE$%", it works Also, I tried creating an active link prior to this, set a char temp field to $DATE$, then pass that variable : (Fields1.form2 LIKE "%$TEMP%") , this fails However, if the date is defined (which we need it the variable), so set to (Fields1.form2 LIKE "%$04/14/2011%"), it works In activelink, DATE command can it be used in this way? Have a great day, D _attend WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are"_
