Device:Export Node wrong HOUR timestamp

[Jose_Cruz]

Currently I have a dashboard Report Input Control Box that triggers a dashboard Device:Export Losant API process with 3 options for ‘back in time’ reporting (in ms) : 24 hrs, 7 days and 30 days

The report is sent to an e-mail, looks great - but the actual HOUR in the ISO Date is ‘off’ by 5 hours (I’m assuming is a Time Zone issue as I’m in GMT-5)

I tried various things, looked for solutions on the Forums, including adding a 5hr difference/Time Zone option in the dashboard box

But I just end up actually offsetting not just the HOUR but ALL data by 5 HOURS since the problem here is just the HOUR ‘stamp’, not the whole data. I can ‘fix’ this in the final CSV/XLS VBA report, but was wondering if I’m missing something or if there’s a way to do it right out of the platform which would be best. All suggestions are welcomed. Thanks,

[JuliaKempf]

Hi @Jose_Cruz,

I might recommend trying out the {{formatDate }} helper or the Date/Time Node. I frequently use these with a template of YYYY-MM-DDThh:mm:ss[Z], as it forms my timestamp without the UTC offset. This should remove the 5-hour date change you are seeing while still displaying the time correctly.

Please let me know if this does not work with your use case!

Thanks,
Julia

[Jose_Cruz]

Ok, let me try that and I’ll get back to you - as always, thank you and Merry Xmas to all at Losant.