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"

Reply via email to