# Adjust date column in a table

**URL:** <https://forum.inductiveautomation.com/t/adjust-date-column-in-a-table/16853>\
**Category:** Ignition\
**Created:** [February 2, 2018, 5:02pm UTC](https://forum.inductiveautomation.com/t/adjust-date-column-in-a-table/16853 "2018-02-02T17:02:33Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![pjgonzales](https://avatars.discourse-cdn.com/v4/letter/p/59ef9b/32.png) [@pjgonzales](https://forum.inductiveautomation.com/u/pjgonzales)\
**Post date:** [February 2, 2018, 5:02pm UTC](https://forum.inductiveautomation.com/t/adjust-date-column-in-a-table/16853/1 "2018-02-02T17:02:33Z")

</div>

I have a table pulling tag history for a few tags at 2am every morning. The problem is that the data values are actually for the previous days totals. I need to find a way to adjust the t\_stamp column by -24 hours so it displays the previous day (where the data applies) instead of the day the record was recorded. Any ideas? Thanks.