Karthick, It is years since I have done this type of calculations.
In your example I would find the first day of the next month and then just take minus one day. The outcome would the last day of the month you are in. ~ Terje From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Karthick S Sent: Wednesday, May 07, 2014 8:50 AM To: arslist@ARSLIST.ORG Subject: Set Month End Date ** I need to Set a Month End Date in a field Called Due Date. Please find the below. Example: Ticket created Date is 7/05/2014 12:00:00 AM and the Due Date should have 31/05/2014 11:59:59 PM. it should automatically calculate or populate the Month End Date in Due Date field. I have used this condition "((((($DATE$ + 43200) + (86400 * 31)) - (86400 * DAY((($DATE$ + 43200) + (31 * 86400))))) - (3600 * HOUR((($DATE$ + 43200) + (31 * 86400))))) + (DAY($DATE$) * 86400)) - 1", Which given me the Due Date as "7/06/2014 11:59:00 PM". Can any one help me on this, Please. _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"