You’re offline. This is a read only version of the page.
1,655
Hi to All,
I am facing some strange issue in the ssrs sql report.
I am using Ax 2009 on time zone (GMT-05:00) Eastern time(US and canada). i have created some data in Ax salesLineTable.
I have created a ssrs sql report and fetch the data from the SQL query , salesline table but its showing created date time diff. in my report.
like as i have created data in ax on 25/12/2014 10:00:00 PM in ax and now its showing in sql 26/12/2014 02:00:00 AM.
So how i can manage time zone to get data in sql report as data inserted in Ax??
Please help me on this issue.
*This post is locked for comments
I have the same question (0)
You need consider SQL server methods to convert date for specific time zone
stackoverflow.com/.../effectively-converting-dates-between-utc-and-local-ie-pst-time-in-sql-2005
Please verify and let me know if you need more information.
Share
Report
All responses (
Answers (
