Hi All, Our remedy version is 7.1, Server - Windows 2003 R2 Server, Datebase - MS SQL 2005.
*In Dev System:* I used the below date function in one of the workflow, which worked fine and the result were as expected. I got the date is '30/09/2014 11:59:59 PM'. DATEADD( "day", ( - DATENUM( "day", DATEADD( "month", 1, $DATE$))), DATEADD( "month", 1, $DATE$)) + (86400 - 1) *In Production:* When i used the same Date function in Production system, it give the Date '02/01/1970 11:00:30 AM' The issue looks very strange and i am unable to figure it out, please help me on this. *Thanks and Regards,* *Karthick S* _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"