Try this Action 1 sets the date to the first of next month Action 2 subtracts 1 minute
Action 1: Set Fields
Field : Due Date
Value: DATEADD("mm", 1, DATEADD("dd", -(DAY($Create Date$) - 1), $Create
Date$))
Action 2: Set Fields
Field: Due Date
Value: $Due Date$ - 60
Greg Givens
-----Original Message-----
From: Action Request System discussion list(ARSList)
[mailto:[email protected]] On Behalf Of Karthick S
Sent: Wednesday, May 07, 2014 2:50 AM
To: [email protected]
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"
smime.p7s
Description: S/MIME cryptographic signature
