The DateNum function is your friend here, try this
Have a temp character field and set it to be:
Temp Character = (DATENUM("mm", $DATE$) +1) + "/1/") + YEAR($TIMESTAMP$) (You
may have to reformat this a bit depending on Locale)
Then have another set fields into a temp date field that does
Temp Date = $Temp Character$
Then one more that does DueDate = $Temp Date$ - 1
I haven't tested this but it should work
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Karthick S
Sent: Wednesday, May 07, 2014 3: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"
