Hi Frank, Thanks for your reply. It's not SHR:People but SHR:Report form. By the way why *17? Is (60*60*17) = (sec*min*?) Do we need to take note of the current timestamp as well and minute the hours depend on when you click the button today? _____
From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Frank Caruso Sent: Wednesday, 22 November, 2006 11:24 To: arslist@ARSLIST.ORG Subject: Re: Active Link to get yesterday date report ** I think you are asking to create an active link that works by button click and displays all records in the SHR:People form that were created yesterdat at 7 AM to today at 7AM. If so then ... Create the active link on a form. Attach a button to it. Create an Open Window action that does Window Type Modify Pick a Display Type Select the Server and Form (SHR:People) In the qualification field enter the following: '3' >=$DATE$-(60*60*17) and '3' <=$DATE$+(60*60*17) Note: I used " '3' " because I do not know the field names on SHR:People. You might be able to user " 'Create Date'" See if that gets you started. On 11/21/06, Siti Hawa Bee SHAIK FARID <[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> > wrote: ** I really need your expect guidance in this. I want to create an active to act on a button in SHR:Reporting to automatically set the Qualification to yesterday's date from 0700hr to today's day 0700hr. Creating the button is alright but need help to create the active link. How can I do this? Can anyone help? Best Regards, Siti Hawa Bee |||| UOB Group, TSD - IT Helpdesk *: << << <mailto:[EMAIL PROTECTED]> mailto: [EMAIL PROTECTED] >>>> My Favourite Quote " No person can be a great leader unless he takes genuine joy in successes of those under him" - W A Nance United Overseas Bank Limited Singapore Company Reg No. 193500026Z Privileged/Confidential information may be contained in this communication (which includes any attachment). If you are not an intended recipient, you must not use, copy, disclose, distribute or retain this communication or any part of it. Instead, please delete all copies of this communication from your computer system and notify the sender immediately by reply email. Thank you. __20060125_______________________This posting was submitted with HTML in it___ -- Frank Caruso Specific Integration, Inc. Senior Remedy Engineer www.specificintegration.com <http://www.specificintegration.com> 703-376-1249 __20060125_______________________This posting was submitted with HTML in it___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"