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: [email protected] 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"
