Select to view content in your preferred language

Time shown in report is off by 6 hours - how do I fix this?

216
2
Jump to solution
a month ago
AdamGebhart
Frequent Contributor

My survey includes a dateTime field for the user to select the date and time of an incident.  The correct value is being carried over to my feature layer.  However, the time is off by 6 hours when displayed in my report.  What do I need to do in the report to show the correct time?

Here is a test submission I made this morning for an incident that occurred the previous day at 9:00 am.  The correct time and date carry over to the feature layer.

AdamGebhart_0-1762442082018.png

Here is my report template and output.  Notice the 6 hour difference?  Is something wrong with my time format?

AdamGebhart_1-1762442220562.png 

AdamGebhart_2-1762442238278.png

 

 

 

0 Kudos
1 Solution

Accepted Solutions
AdamGebhart
Frequent Contributor

@clt_cabq Thanks for that.

I actually found my mistake and should have waited a little bit longer before posting the question.

The issue was in the time format.  I changed it to ${bite_time | format:"H:mm A"} and now I get the correct time.

AdamGebhart_1-1762443244539.png

 

AdamGebhart_0-1762443128272.png

 

View solution in original post

2 Replies
clt_cabq
Frequent Contributor

Not sure where you are but this sounds like it could be a UTC to local time issue.. here's one article that describes how to convert those UTC values to your local time

how to convert UTC time to local time zone 

AdamGebhart
Frequent Contributor

@clt_cabq Thanks for that.

I actually found my mistake and should have waited a little bit longer before posting the question.

The issue was in the time format.  I changed it to ${bite_time | format:"H:mm A"} and now I get the correct time.

AdamGebhart_1-1762443244539.png

 

AdamGebhart_0-1762443128272.png