Hi All,
Urgency:Yes
Version:5.5 CU3
I have developed a finder screen for Order Release .I create a order release with twos cenarios:
1.Give early pickupdate as oct 10,2007,00:00 hrs and let the order release gid be assumed as 'X1'(after creation)
2.Give early pickupdate as oct 10,2007,07:00 hrs and let the order release gid be assumed as 'X2'(after creation)
But When I search with early pickupdate as Oct 9,2007 I get to see the 'X1' order release.And When I serach with early pickupdate as Oct10,2007,I see only 'X2' order release.The reason is because in DB,it stores for 'X1' order release,the early pickupdate as Oct 9,2007:22:00 hrs and for 'X2' order release,the early pickupdate as Oct 10,2007:05:00 hrs.That means what value I give,it subtracts 2 hrs less and stores in DB.So I get 'X1' order release record also when I search with early pickupdate as Oct 9,2007 .
Can anyone let me know how to make the time in DB and UI in synch.Also please let me know if my understanding is wrong and also the solution for the above problem.
I have not set any preference regarding time zone.The time dispalyed in UI is from CET standard.
Thanking and regards,
Nikesh.
Urgency:Yes
Version:5.5 CU3
I have developed a finder screen for Order Release .I create a order release with twos cenarios:
1.Give early pickupdate as oct 10,2007,00:00 hrs and let the order release gid be assumed as 'X1'(after creation)
2.Give early pickupdate as oct 10,2007,07:00 hrs and let the order release gid be assumed as 'X2'(after creation)
But When I search with early pickupdate as Oct 9,2007 I get to see the 'X1' order release.And When I serach with early pickupdate as Oct10,2007,I see only 'X2' order release.The reason is because in DB,it stores for 'X1' order release,the early pickupdate as Oct 9,2007:22:00 hrs and for 'X2' order release,the early pickupdate as Oct 10,2007:05:00 hrs.That means what value I give,it subtracts 2 hrs less and stores in DB.So I get 'X1' order release record also when I search with early pickupdate as Oct 9,2007 .
Can anyone let me know how to make the time in DB and UI in synch.Also please let me know if my understanding is wrong and also the solution for the above problem.
I have not set any preference regarding time zone.The time dispalyed in UI is from CET standard.
Thanking and regards,
Nikesh.
Comment