# Help With Date Formatting in Report

**URL:** <https://forum.inductiveautomation.com/t/help-with-date-formatting-in-report/57556>\
**Category:** Ignition\
**Tags:** ignition81\
**Created:** [March 23, 2022, 6:59pm UTC](https://forum.inductiveautomation.com/t/help-with-date-formatting-in-report/57556 "2022-03-23T18:59:30Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Ryan\_Corey](https://avatars.discourse-cdn.com/v4/letter/r/5e9695/32.png) [@Ryan\_Corey](https://forum.inductiveautomation.com/u/Ryan_Corey)\
**Post date:** [March 23, 2022, 6:59pm UTC](https://forum.inductiveautomation.com/t/help-with-date-formatting-in-report/57556/1 "2022-03-23T18:59:31Z")

</div>

I am using Ignition 8.1.15.

I have a date parameter that has an experssion of:

dateFormat(“2022-03-07 00:01:00”,“yyyy-MM-dd 00:01:00”)

When I drag this parameter onto the report and give it formatting of MMMM d, yyyy in the properties window and preview the report it does not change anything and shows up as 2022-03-07 00:01:00. Is this a bug or is there something else I need to do to format it correctly?

---

<div class="post-metadata">

**Author:** ![kvane](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/kvane/32/22228_2.png) [@kvane](https://forum.inductiveautomation.com/u/kvane)\
**Post date:** [March 23, 2022, 7:06pm UTC](https://forum.inductiveautomation.com/t/help-with-date-formatting-in-report/57556/2 "2022-03-23T19:06:48Z")

</div>

[dateFormat()](https://docs.inductiveautomation.com/display/DOC81/dateFormat) returns a String so the Date Format property is not going to be applied to it. Make sure the parameter is Date type, and then add the expression [toDate()](https://docs.inductiveautomation.com/display/DOC81/toDate) around the dateFormat().

![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/2/8/28894c8ec956ea5338afc81148b60ee83ee6d5d3.png)

---

<div class="post-metadata">

**Author:** ![Ryan\_Corey](https://avatars.discourse-cdn.com/v4/letter/r/5e9695/32.png) [@Ryan\_Corey](https://forum.inductiveautomation.com/u/Ryan_Corey)\
**Post date:** [March 23, 2022, 8:00pm UTC](https://forum.inductiveautomation.com/t/help-with-date-formatting-in-report/57556/3 "2022-03-23T20:00:51Z")

</div>

Thanks, I appreciate it. Turns out this parameter was mistakingly configured anyway so we ended up creating a new one that both shows up properly in the report and works with our stored procedure. I appreciate the help anyway.