Forum Discussion

team_aras_meupe_com's avatar
team_aras_meupe_com
Creator III
3 years ago
Solved

Problem with the use of dates.

Problem with the use of dates. I'm going to go crazy with ARAS. After several hours using dates, and it didn't work out, I discovered date is stored in the databse in "neutral" date, here in Spain ...
  • angela's avatar
    angela
    3 years ago

    Hi,

    it should not be necessary to hard-code the time zone difference. Cause this could lead to trouble with summer/winter time changes.

    I so far didn´t needed "get" queries that required exact hour/minutes filters so I right now don´t know a solution for your scenario. I most of the time just "write" timings. I wonder if and how the regular grid search options consider the time zone difference. 

    I think as the date  is stored in neutral format, you also must use neutral format when searching. So convert your current date to neutral before using it as filter. 

    Have you checked the internationalization guide? It contains a few code samples regarding writing the time in neutral format. 

    www.aras.com/.../aras-innovator-120--configuring-internationalization.ashx

angela's avatar
angela
Catalyst II
3 years ago

Hi,

it should not be necessary to hard-code the time zone difference. Cause this could lead to trouble with summer/winter time changes.

I so far didn´t needed "get" queries that required exact hour/minutes filters so I right now don´t know a solution for your scenario. I most of the time just "write" timings. I wonder if and how the regular grid search options consider the time zone difference. 

I think as the date  is stored in neutral format, you also must use neutral format when searching. So convert your current date to neutral before using it as filter. 

Have you checked the internationalization guide? It contains a few code samples regarding writing the time in neutral format. 

www.aras.com/.../aras-innovator-120--configuring-internationalization.ashx

  • team_aras_meupe_com's avatar
    team_aras_meupe_com
    Creator III
    3 years ago

    Hello, too many thanks.

    Yes, i will use neutral format.

    Thanks!!