# Report Designer - Static CSV date format

**URL:** <https://forum.inductiveautomation.com/t/report-designer-static-csv-date-format/22480>\
**Category:** Ignition\
**Created:** [February 11, 2019, 8:03pm UTC](https://forum.inductiveautomation.com/t/report-designer-static-csv-date-format/22480 "2019-02-11T20:03:09Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![nbester](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/nbester/32/4646_2.png) [@nbester](https://forum.inductiveautomation.com/u/nbester)\
**Post date:** [February 11, 2019, 8:03pm UTC](https://forum.inductiveautomation.com/t/report-designer-static-csv-date-format/22480/1 "2019-02-11T20:03:09Z")

</div>

I am using the static CSV data source to import some placeholder data for a report. Does anyone know if it’s possible to have the report designer recognize one of the columns as a timestamp? It appears to read everything as strings and even after inputing data in a standard date time format, it still won’t treat it as date time. Would my only option be to import my test data from a SQL query instead?

Thanks!

---

<div class="post-metadata">

**Author:** ![jpark](https://avatars.discourse-cdn.com/v4/letter/j/a88e57/32.png) [@jpark](https://forum.inductiveautomation.com/u/jpark)\
**Post date:** [February 11, 2019, 8:24pm UTC](https://forum.inductiveautomation.com/t/report-designer-static-csv-date-format/22480/2 "2019-02-11T20:24:22Z")

</div>

You can use a dataset tag.

---

<div class="post-metadata">

**Author:** ![nbester](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/nbester/32/4646_2.png) [@nbester](https://forum.inductiveautomation.com/u/nbester)\
**Post date:** [February 11, 2019, 8:40pm UTC](https://forum.inductiveautomation.com/t/report-designer-static-csv-date-format/22480/3 "2019-02-11T20:40:36Z")

</div>

That works great, should have thought of that. Thanks jpark.
