Hi Thomas, Thanks for your reply. I contacted BMC support for using one of the existing $PROCESS$ date function by using Business Time Segment form in ARS V7. I will wait for their reply and in the mean time I will try other alternates either by using one of the direct SQL queries or temp form filled with dates ( It is a manual effort). Thanks, Salehjee Ahmed.
________________________________ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Thomas Bean Sent: Friday, November 07, 2008 4:44 PM To: [email protected] Subject: Re: Date Calculation ** I think I would probably approach this calculation by using a database function rather than ARS workflow. What database are you using? If you are using MS-SQL, the following article has some examples that may be helpful: http://www.databasejournal.com/features/mssql/article.php/3076421/Exampl es-of-how-to-Calculate-Different-SQL-Server-Dates.htm --Thomas ----- Original Message ----- From: Salehjee Ahmed <mailto:[EMAIL PROTECTED]> Newsgroups: gmane.comp.crm.arsystem.general To: [email protected] Sent: Thursday, November 06, 2008 8:11 AM Subject: Date Calculation ** Hi, I am trying to find a way to auto calculate the date for 3rd Sunday of next month based on current date either using one of the built-in-function or any other logic. Thanks, Salehjee Ahmed. __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
