# Date format not same as Named Query in Table PRESPETIVE

**URL:** <https://forum.inductiveautomation.com/t/date-format-not-same-as-named-query-in-table-prespetive/70062>\
**Category:** Ignition\
**Tags:** ignition81, scripting, database, python, perspective\
**Created:** [February 20, 2023, 1:04pm UTC](https://forum.inductiveautomation.com/t/date-format-not-same-as-named-query-in-table-prespetive/70062 "2023-02-20T13:04:56Z")\
**Posts on this page:** 1\
**Showing post:** 3

<div class="post-metadata">

**Author:** ![justinedwards.jle](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/justinedwards.jle/32/37854_2.png) [@justinedwards.jle](https://forum.inductiveautomation.com/u/justinedwards.jle)\
**Post date:** [February 20, 2023, 1:15pm UTC](https://forum.inductiveautomation.com/t/date-format-not-same-as-named-query-in-table-prespetive/70062/3 "2023-02-20T13:15:06Z")

</div>

Here's another forum post where the same problem was solved:

> [@Two Tables Question Using Text Fields](https://forum.inductiveautomation.com/t/two-tables-question-using-text-fields/64485/9):
>
> you need to add a mapping to those three text fields to map their values to a datetime Here i added a custom property called valueIn (that’s where you’d be writing your value to instead of the text property) Then add a binding on text to this.custom.valueIn and finally a Format Transform setup with whichever datetime format you want to display

---

_[View the full topic](https://forum.inductiveautomation.com/t/date-format-not-same-as-named-query-in-table-prespetive/70062)._