# Formatting Dates in a Report Bar Chart

**URL:** <https://forum.inductiveautomation.com/t/formatting-dates-in-a-report-bar-chart/92357>\
**Category:** Ignition\
**Tags:** ignition79, vision, reporting\
**Created:** [June 25, 2024, 6:18pm UTC](https://forum.inductiveautomation.com/t/formatting-dates-in-a-report-bar-chart/92357 "2024-06-25T18:18:03Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![rprice](https://avatars.discourse-cdn.com/v4/letter/r/35a633/32.png) [@rprice](https://forum.inductiveautomation.com/u/rprice)\
**Post date:** [June 25, 2024, 6:18pm UTC](https://forum.inductiveautomation.com/t/formatting-dates-in-a-report-bar-chart/92357/1 "2024-06-25T18:18:03Z")

</div>

Hi, I am creating a report using Historical Tags. In this report, I'd like to have a bar chart displaying my data. When I created this chart, the dates along the x-axis are very long and illegible.  
 ![reportbargraph](https://us1.discourse-cdn.com/inductiveautomation/original/3X/7/d/7d65fad9e0607ecd799e6100bc55a561a1f9198b.png)  
I was able to create a similar bar chart in a Vision client, where I was able to create a new dataset and format the timestamps.  
 ![visionbargraph](https://us1.discourse-cdn.com/inductiveautomation/original/3X/2/2/2269754e8e1652560ba8f7cc711c8d30f684ed48.png)  
Is there any way to format my timestamps in a report to look similar to the ones in my Vision client?

---

<div class="post-metadata">

**Author:** ![schenk](https://avatars.discourse-cdn.com/v4/letter/s/6bbea6/32.png) [@schenk](https://forum.inductiveautomation.com/u/schenk)\
**Post date:** [June 26, 2024, 11:31pm UTC](https://forum.inductiveautomation.com/t/formatting-dates-in-a-report-bar-chart/92357/2 "2024-06-26T23:31:23Z")

</div>

In a brief search, I wasn't able to find a good way through the `configureChart` extension function for a category chart.

Assuming 7.9.7 or later, you could try adding a Script Data Source after the Tag Historian Data Source with this script

```python
def updateData(data, sample):
	data['formattedData'] = system.dataset.formatDates(data['originalData'].coreResults, 'MM/dd')

```

Then change the Data Key on the chart to `formattedData`