Hi,
Please don't use char-fields like this. They are dependent on the language
settings, and will be unpredictable especially on the client side via Active
Links.
Best Regards - Misi, RRR AB, http://rrr.se
> 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"
>
> --
> This message was scanned by ESVA and is believed to be clean.
>
>
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"
