Date Problem

オフライン
hii i have one item type QDM having field which datatype is date and pattern is shortdate i select 4/28/2017 date where 4 is month , 28 is day and save item then i open sql server and  open data for QDM , the date selected is stored as 4/27/2017 (one day less than i selected) it is only problem with short date if i change pattern to short datetime then date stored in sql is correctly please help me
Parents
  • Hi rrt, Can you confirm the time zone of the client, and whether there is a corporate time zone set in the database? I believe the discrepancy you are seeing is related to how the Aras client converts the client machine date/time to UTC when it is stored in the database.
    Eli Donahue Aras Labs Software Engineer
Reply
  • Hi rrt, Can you confirm the time zone of the client, and whether there is a corporate time zone set in the database? I believe the discrepancy you are seeing is related to how the Aras client converts the client machine date/time to UTC when it is stored in the database.
    Eli Donahue Aras Labs Software Engineer
Children
No Data