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"
