Hi
I have created a functionality in Appian to show complaint details in a grid where i have Complaint logged date. Additionally, I've set up a report tab where the same information can be exported. However, I encountered an issue with date discrepancies after changing Appian locale time zone Central America to New Zealand. The complaint logged dates in the grid and report are different now. How can I resolve this?.
Discussion posts and replies are publicly visible
Which one is incorrect? the one in the report or the one in the grid?
Report complaint logged date showing incorrect. system complaint logged date showing correct as per new zealand timezone
Report Date is showing one day behind grid complaint logged date
Coud you try using datevalue(local(<date>)) on your report?
that report value is taking from one view table
when we download report that time this date discrepancy is showing between Grid and report
In the export, data is always in UTC, while the data you see on screen is translated into the timezone of your user account.
I know, the problem is that your report is not using the locale with the date... with the function suggested in the date column should work...
Thank you Stefan but while exporting the report data that data is coming from different tab that is not appian inbuild export
i tried but not working report data timezone is Central time(America/chicago) and i need to convert that logged date in to new Zealand timezone. because user timezone set NewZealand in Appian
Central time where? In the database?