Change date time to format 24H

hello everyone, I’m new to eazybi, and I’m working on a French project where they use dates in 24H00 format
my table
calculated field

when I try the following syntax the format returned is always AM/PM

[Issue].CurrentHierarchyMember.GetDate('Resolved at'),'yyyy-mm-dd HH:MM'

Hey @lahcen

Why would you think that your resolution dates are in AM/PM format?
Have you compared the resolution dates from the eazyBI report with Jira issue screen to discover the problem?
Your screenshot won’t illustrate the problem precisely.
For example, can you share a screenshot from Jira showing the time when issue SI-16485 was created?

eazyBI won’t force the AM/PM format. Vice versa, it by default would use the month day year format for date picker field values (including created date and resolution date).

If that is really the case and there is 12h off, please check if Time options has the same timezone as in your Jira system:

Martins / eazyBI

Thank you martins !!
Indeed, I have a misconfiguration at the timezone level, which is causing the hours to be offset in the business intelligence reporting

1 Like