Re: last working day function- help
Dear Shibu, You can use the DATE function to get the current date and then use DATEADD, DATEDIFF functions to add dates to the current date accordingly using set field actions. Hope this helps. let me know if you require a detailed explanation on this. Regards, Roney Samuel Varghese On 3/21/07, Frank Caruso <[EMAIL PROTECTED]> wrote: ** Depending on the database you are on it may have some built in functions to give such data. On 3/21/07, David Sanders < [EMAIL PROTECTED]> wrote: > > Hi Samuel > > You should be able to find this by setting a data/time field to the > FIRST > day of next month at 00:00:00, then using Business Time functionality > (using > the workdays entry you use) to subtract a second from that. You can > then > use DATE() on the value returned. > > HTH > > David Sanders > Remedy Solution Architect > Enterprise Service Suite @ Work > == > ARS List Award Winner 2005 > Best 3rd party Remedy Application > > tel +44 1494 468980 > mobile +44 7710 377761 > email [EMAIL PROTECTED] > > web http://www.westoverconsulting.co.uk > > > -Original Message- > From: Action Request System discussion list(ARSList) > [mailto:[EMAIL PROTECTED] On Behalf Of Shibu Samuel > Sent: Wednesday, March 21, 2007 3:36 PM > To: arslist@ARSLIST.ORG > Subject: last working day function- help > > Hi List, > > > > Is there any function in remedy to set the last working day of the > month(or > last friday of the month). > > > > for Ex: User will select month from the dropdown and the field x will be > > populated with the last working date > > or any workaround. > > > > Thanks > > Shibu Samuel > > > ___ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where > the Answers Are" > -- Frank Caruso Specific Integration, Inc. Senior Remedy Engineer, ITIL Foundation Certified 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"
Re: last working day function- help
Depending on the database you are on it may have some built in functions to give such data. On 3/21/07, David Sanders <[EMAIL PROTECTED]> wrote: Hi Samuel You should be able to find this by setting a data/time field to the FIRST day of next month at 00:00:00, then using Business Time functionality (using the workdays entry you use) to subtract a second from that. You can then use DATE() on the value returned. HTH David Sanders Remedy Solution Architect Enterprise Service Suite @ Work == ARS List Award Winner 2005 Best 3rd party Remedy Application tel +44 1494 468980 mobile +44 7710 377761 email [EMAIL PROTECTED] web http://www.westoverconsulting.co.uk -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Shibu Samuel Sent: Wednesday, March 21, 2007 3:36 PM To: arslist@ARSLIST.ORG Subject: last working day function- help Hi List, Is there any function in remedy to set the last working day of the month(or last friday of the month). for Ex: User will select month from the dropdown and the field x will be populated with the last working date or any workaround. Thanks Shibu Samuel ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are" -- Frank Caruso Specific Integration, Inc. Senior Remedy Engineer, ITIL Foundation Certified www.specificintegration.com 703-376-1249 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
Re: last working day function- help
Hi Samuel You should be able to find this by setting a data/time field to the FIRST day of next month at 00:00:00, then using Business Time functionality (using the workdays entry you use) to subtract a second from that. You can then use DATE() on the value returned. HTH David Sanders Remedy Solution Architect Enterprise Service Suite @ Work == ARS List Award Winner 2005 Best 3rd party Remedy Application tel +44 1494 468980 mobile +44 7710 377761 email [EMAIL PROTECTED] web http://www.westoverconsulting.co.uk -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Shibu Samuel Sent: Wednesday, March 21, 2007 3:36 PM To: arslist@ARSLIST.ORG Subject: last working day function- help Hi List, Is there any function in remedy to set the last working day of the month(or last friday of the month). for Ex: User will select month from the dropdown and the field x will be populated with the last working date or any workaround. Thanks Shibu Samuel ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
last working day function- help
Hi List, Is there any function in remedy to set the last working day of the month(or last friday of the month). for Ex: User will select month from the dropdown and the field x will be populated with the last working date or any workaround. Thanks Shibu Samuel
