Thanks Misi..
On Thu, May 8, 2014 at 4:40 AM, Misi Mladoniczky <m...@rrr.se> wrote:
> Hi,
>
> First you find the start point of the month:
> MonthStart = DATEADD("dd", 1 - DAY($DATE$), $DATE$)
>
> Then you find the first of the next month and subtract one second:
> MonthEnd = DATEADD("mm", 1, $MonthStart$) - 1
>
> And you can do this in a single step:
> DATEADD("mm", 1, DATEADD("dd", 1 - DAY($DATE$), $DATE$)) - 1
>
> Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011)
>
> Ask the Remedy Licensing Experts (Best R.O.I. Award at WWRUG10/11/12/13):
> * RRR|License - Not enough Remedy licenses? Save money by optimizing.
> * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs.
> Find these products, and many free tools and utilities, at http://rrr.se.
>
> > Can anyone help me in this calculation
> >
> >
> >
> > Need to calculate Current Date + No. of Days in a Month.
> >
> >
> >
> > We have process to create automated ticket in Remedy, so when a ticket is
> > created the End Date of the ticket should be Month End Date.
> >
> >
> >
> > Example: If a Ticket created in Current Date is 7/05/2014 12:00:00 AM and
> > the End Date should have 31/05/2014 11:59:59 PM.
> >
> >
> >
> > Kindly provide your suggestion on this.
> >
> >
> > Regards,
> >
> > Karthick S
> >
> >
> _______________________________________________________________________________
> > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
> > "Where the Answers Are, and have been for 20 years"
> >
>
>
> _______________________________________________________________________________
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
> "Where the Answers Are, and have been for 20 years"
>
--
*Thanks and Regards,*
*Karthick S*
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"
