Maybe use the Month function to obtain the month from the date and add one to move to the next month. Then use that part of the date to get to mm+1/01/yyyy - then subtract one second. Can probably do it all in one set field command with a bit of work on the expression.
----- Original Message ----- From: "Karthick S" <[email protected]> To: [email protected] Sent: Tuesday, May 6, 2014 8:36:36 PM Subject: Date Calculation ** 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 _ARSlist: "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"
