Hi All,
Grid>Search>{datefield}>Special Condition was working fine when i had datetime record in utc and my production webserver’s localtime was set to utc. But in new project i have db record with GMT+5 so i set webserver local timezone as Etc/GMT+5 or Asia/Karachi. I realized that special condition are picking utc time instead of localtime.
e.g. at the time of writing this topic current local time is 2024-17-17 00:58:00 and utc is 19:58:00. when i select last hour from special condition, it shows -1 hour and 19:58:00 instead of -1 hour and 00:58:00.
My development is windows based where special condition showing accurate hours on selection, while my production is linux based lampp server and always shows hours according utc time instead of server’s localtime. Am I missing something or could you explain how special condition selecting datetime.
Thanks in advance for clarification.
Umar
