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
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?
Yes
Grid Details coming from USER System timezone that is New Zealand
and Report value is coming from one View table In the view table complaint logged date is showing as per New zealand timeZone but when generate report and download that report that time the Complaint Logged date is showing one day behind of Newzeland timezone like in the grid is showing 3/13/2024 but in the report showing 3/12/2024
can we do anything with process model on the submit button
yes
Thanks you all of you now issue has resolved