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"
