# Report date issue

**URL:** <https://forum.inductiveautomation.com/t/report-date-issue/12507>\
**Category:** Ignition\
**Created:** [January 3, 2017, 11:02am UTC](https://forum.inductiveautomation.com/t/report-date-issue/12507 "2017-01-03T11:02:07Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![HALW80](https://avatars.discourse-cdn.com/v4/letter/h/47e85d/32.png) [@HALW80](https://forum.inductiveautomation.com/u/HALW80)\
**Post date:** [January 3, 2017, 11:02am UTC](https://forum.inductiveautomation.com/t/report-date-issue/12507/1 "2017-01-03T11:02:07Z")

</div>

We have a report which uses the dateArithmetic function:

dateFormat(dateArithmetic({Root Container.Popup Calendar.date}, -1, “days”), “dd-MM-YYYY”)  
dateFormat(dateArithmetic({Root Container.Popup Calendar.date}, -2, “days”), “dd-MM-YYYY”)  
dateFormat(dateArithmetic({Root Container.Popup Calendar.date}, -3, “days”), “dd-MM-YYYY”)  
etc

When a client is open the value for the 1/1/2017 from data base is correct but the header shows the 1/1/2016

In designer when I run the test button and change the calendar it shows the 1/1/2017 as expected.

---

<div class="post-metadata">

**Author:** ![KathyApplebaum](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/kathyapplebaum/32/7261_2.png) [@KathyApplebaum](https://forum.inductiveautomation.com/u/KathyApplebaum)\
**Post date:** [January 3, 2017, 3:26pm UTC](https://forum.inductiveautomation.com/t/report-date-issue/12507/2 "2017-01-03T15:26:49Z")

</div>

Can you give us a little more info? It would help to know what version of Ignition you’re running, and what version of java the Designer and Client are running. Are the Designer and Client on the same machine?

---

<div class="post-metadata">

**Author:** ![HALW80](https://avatars.discourse-cdn.com/v4/letter/h/47e85d/32.png) [@HALW80](https://forum.inductiveautomation.com/u/HALW80)\
**Post date:** [January 3, 2017, 4:19pm UTC](https://forum.inductiveautomation.com/t/report-date-issue/12507/3 "2017-01-03T16:19:18Z")

</div>

Java 8 v73  
Ignition 7.8.2  
Yes Designer and Client on the one machine

---

<div class="post-metadata">

**Author:** ![HALW80](https://avatars.discourse-cdn.com/v4/letter/h/47e85d/32.png) [@HALW80](https://forum.inductiveautomation.com/u/HALW80)\
**Post date:** [January 3, 2017, 4:23pm UTC](https://forum.inductiveautomation.com/t/report-date-issue/12507/4 "2017-01-03T16:23:37Z")

</div>

Its fine when I don’t include 1/1/2017

---

<div class="post-metadata">

**Author:** ![HALW80](https://avatars.discourse-cdn.com/v4/letter/h/47e85d/32.png) [@HALW80](https://forum.inductiveautomation.com/u/HALW80)\
**Post date:** [January 3, 2017, 4:25pm UTC](https://forum.inductiveautomation.com/t/report-date-issue/12507/5 "2017-01-03T16:25:36Z")

</div>

samples

---

<div class="post-metadata">

**Author:** ![KathyApplebaum](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/kathyapplebaum/32/7261_2.png) [@KathyApplebaum](https://forum.inductiveautomation.com/u/KathyApplebaum)\
**Post date:** [January 3, 2017, 4:36pm UTC](https://forum.inductiveautomation.com/t/report-date-issue/12507/6 "2017-01-03T16:36:01Z")

</div>

Can you contact support on this? I’m not able to replicate the issue with Ignition 7.8.5 and Java 8u91. ☹

---

<div class="post-metadata">

**Author:** ![HALW80](https://avatars.discourse-cdn.com/v4/letter/h/47e85d/32.png) [@HALW80](https://forum.inductiveautomation.com/u/HALW80)\
**Post date:** [January 9, 2017, 2:22pm UTC](https://forum.inductiveautomation.com/t/report-date-issue/12507/7 "2017-01-09T14:22:01Z")

</div>

Thanks Kathy, will do

---

<div class="post-metadata">

**Author:** ![Kraenbring](https://avatars.discourse-cdn.com/v4/letter/k/f4b2a3/32.png) [@Kraenbring](https://forum.inductiveautomation.com/u/Kraenbring)\
**Post date:** [December 30, 2019, 11:17pm UTC](https://forum.inductiveautomation.com/t/report-date-issue/12507/8 "2019-12-30T23:17:28Z")

</div>

Just in case anyone is looking for the answer, I just figured it out on my 7.9.9 server.

Change the YYYY to yyyy