raviraj - Saturday, March 19, 2011 4:00 AM:
Hello all,
when i get date from aras i get one day difference with actual date.. i checked in SQL Database and date which i get .. it shows the one day difference.
whats the Problem.do anybody know this....
actually i m working from India will it affect on result.....?
vishal_trivedi - Wednesday, April 6, 2011 8:09 AM:
Hi Ravi,
Check whole string of date you might be getting time with it.
So, combination of date and time can create such problems.
Just extract date from your 'date string' then try.
Vishal
aknourenko - Tuesday, April 12, 2011 5:44 PM:
In the database date ime values are stored in UTC. When you connect to Innovator server from a client a session time zone is established; after that all date ime values are returned in the session time zone. The session time zone is either client time zone set in Windows (in case corporate time zone is not set in Innovator) or corporate time zone (in case the corporate time zone is set in Innovator). Finally, if the property of type "Date" has pattern set to, let's say, "short_date" then only date portion of the date ime is send from the server to client. So: a) check if you have a corporate time zone set; b) if not check what is your time zone in Windows; c) what is the "pattern" on the corresponding property.
