mishomor Posted January 11, 2010 Share Posted January 11, 2010 Hi,I have date input control in my report. So if I pick a let's say 01-04-2010 it will show in my report as Sun Jan 03 16:00:00 PST 2010 and of course sql will return wrong data based on Jan-03-2010. It doens't matter what time I choose date it will always cast as one day before at 16:00:00.I checked date, time and timezone on myserver and they are correct (Mon Jan 11 10:39:19 PST 2010). Also timezone of my Data Source is also correct America/Vancouver - Pacific Standard Time.Any idea why my date input control date is wrong?thanks!Post Edited by mishomor at 01/11/2010 18:29 Link to comment Share on other sites More sharing options...
sjongenelen Posted January 12, 2010 Share Posted January 12, 2010 read the forums :) set the data source timezone to blank Link to comment Share on other sites More sharing options...
mishomor Posted January 12, 2010 Author Share Posted January 12, 2010 sjongenelenWrote: read the forums :) set the data source timezone to blank It works .... thanks sjongenelen!! Link to comment Share on other sites More sharing options...
gregg Posted July 6, 2010 Share Posted July 6, 2010 sjongenelenWrote: read the forums :) set the data source timezone to blank Luckily this one came up in search results, doesn't seem this snag that well covered in forums? Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now