# Date/Time Field reports

**URL:** <https://community.eazybi.com/t/date-time-field-reports/5523>\
**Category:** Questions & Answers\
**Created:** [October 27, 2020, 3:20pm UTC](https://community.eazybi.com/t/date-time-field-reports/5523 "2020-10-27T15:20:44Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![auto98](https://community.eazybi.com/letter_avatar_proxy/v4/letter/a/e47774/32.png) [@auto98](https://community.eazybi.com/u/auto98)\
**Post date:** [October 27, 2020, 3:20pm UTC](https://community.eazybi.com/t/date-time-field-reports/5523/1 "2020-10-27T15:20:44Z")

</div>

Hi all,

We use Jira for Change Management, as part of that we have a custom date/time field called “Actual Window Start”.

I’m being asked to produce a report on “In Hours” and “Out of Hours” changes (6am-10pm / 10pm-6am).

I’m struggling to work out how to do this, I can see two options for the output but cant work out how to get to either of them:

1. Use a start date and end date, then between those dates come up with two numbers, one for IH and one for OOH

2. A table that lists it over time, to produce a graph of “Times in AWS field” per issue over time

Any ideas?

---

<div class="post-metadata">

**Author:** ![martins.vanags](https://community.eazybi.com/user_avatar/community.eazybi.com/martins.vanags/32/8905_2.png) [@martins.vanags](https://community.eazybi.com/u/martins.vanags)\
**Post date:** [October 29, 2020, 3:05pm UTC](https://community.eazybi.com/t/date-time-field-reports/5523/2 "2020-10-29T15:05:50Z")

</div>

Hi @auto98

See a similar calculation here:

> [@Issues created out of office hours](https://community.eazybi.com/t/issues-created-out-of-office-hours/180):
>
> There are a couple of ways how to calculate the number of issues created outside office hours. First, let us look at an example to find issues created before 9 am or after 6 pm in eazyBI. To do this, you can define a created hour breakdown dimension with [advanced settings](https://docs.eazybi.com/eazybijira/data-import/custom-fields/advanced-settings-for-custom-fields): [jira.customfield\_hodc] name = "Hour of Day Created" data\_type = "integer" dimension = true javascript\_code = ''' issue.fields.customfield\_hodc = parseInt(issue.fields.created.match(/T(\d\d):/)[1]); ''' Further, select the…

Once you have imported your AWS field in eazyBI as property and measures, there would a few new measures created that you can use to calculate the expected result.

It would be something like this for out of office hours

```
NonZero(
Count(
Filter(
Descendants([Issue].CurrentHierarchyMember,[Issue].[Issue]),
(
Datediffhours(
datewithouttime([Issue].CurrenthierarchyMember.get('Actual Window Start')),
[Issue].CurrenthierarchyMember.get('Actual Window Start'))<6
OR
Datediffhours(
datewithouttime([Issue].CurrenthierarchyMember.get('Actual Window Start')),
[Issue].CurrenthierarchyMember.get('Actual Window Start'))>22
)
AND
[Measures].[Issues with Actual Window Start]>0
)
)
)

```

And a similar you can create for office hours.

Martins / eazyBI support