# Not able to pull the data after 1 pm **URL:** \ **Category:** Ignition\ **Created:** [October 19, 2021, 2:54pm UTC](https://forum.inductiveautomation.com/t/not-able-to-pull-the-data-after-1-pm/52114 "2021-10-19T14:54:40Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![pkhoshroo](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pkhoshroo/32/26801_2.png) [@pkhoshroo](https://forum.inductiveautomation.com/u/pkhoshroo)\ **Post date:** [October 19, 2021, 2:54pm UTC](https://forum.inductiveautomation.com/t/not-able-to-pull-the-data-after-1-pm/52114/1 "2021-10-19T14:54:40Z")
Hello, I have a weird problem here. In my perspective view, I am able to pull the data to my table before 12.59 pm but not for 1 pm and after that. I have no idea what is the problem here. Have you encountered such a thing before? My dataset has a column titled “datetime\_created” and its datatype is **Date** ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/e/d/ed4d487b84c0fffa93c131e8fe4b9c6f5776542e.png) Now in my history table, I am filtering based on a start time and end time. I do not use any format transformation for dates and I am getting this preview: ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/1/a/1aec279a06bfd28b376396fa0877345bc2010320.png) However, I get this error too when I select the desired date/time: Conversion failed when converting date and/or time from character string. I tried pattern transformation, it is working but it is not showing the data after I choose 1 PM and above as an end date. ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/5/b/5b8710b8040300b24fea1f6ab6eb1444d2d89af5.png) [https://us1.discourse-cdn.com/inductiveautomation/original/3X/8/8/886baf8e8f2a6a1ee9b4b5d97f74e8e2bf9228d8.mp4](https://us1.discourse-cdn.com/inductiveautomation/original/3X/8/8/886baf8e8f2a6a1ee9b4b5d97f74e8e2bf9228d8.mp4) ---
**Author:** ![josborn](https://avatars.discourse-cdn.com/v4/letter/j/4bbf92/32.png) [@josborn](https://forum.inductiveautomation.com/u/josborn)\ **Post date:** [October 19, 2021, 5:21pm UTC](https://forum.inductiveautomation.com/t/not-able-to-pull-the-data-after-1-pm/52114/2 "2021-10-19T17:21:57Z")
Check that your date formats are the same, ive seen some weirdness when they didn’t match. ---
**Author:** ![pkhoshroo](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pkhoshroo/32/26801_2.png) [@pkhoshroo](https://forum.inductiveautomation.com/u/pkhoshroo)\ **Post date:** [October 21, 2021, 4:46pm UTC](https://forum.inductiveautomation.com/t/not-able-to-pull-the-data-after-1-pm/52114/3 "2021-10-21T16:46:35Z")
My dataset has a column titled “datetime\_created” and its datatype is **Date** ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/e/d/ed4d487b84c0fffa93c131e8fe4b9c6f5776542e.png) Now in my history table, I am filtering based on a start time and end time. I do not use any format transformation for dates and I am getting this preview: ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/1/a/1aec279a06bfd28b376396fa0877345bc2010320.png) However, I get this error too when I select the desired date/time: Conversion failed when converting date and/or time from character string. I tried pattern transformation, it is working but it is not showing the data after I choose 1 PM and above as an end date. ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/5/b/5b8710b8040300b24fea1f6ab6eb1444d2d89af5.png) ---
**Author:** ![pkhoshroo](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pkhoshroo/32/26801_2.png) [@pkhoshroo](https://forum.inductiveautomation.com/u/pkhoshroo)\ **Post date:** [October 21, 2021, 5:05pm UTC](https://forum.inductiveautomation.com/t/not-able-to-pull-the-data-after-1-pm/52114/4 "2021-10-21T17:05:32Z")
Found the issue! The format pattern is wrong. It should be: yyyy-MM-dd **HH** :mm:ss instead of yyyy-MM-dd **hh** :mm:ss ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/5/b/5b8710b8040300b24fea1f6ab6eb1444d2d89af5.png) ---
**Author:** ![josborn](https://avatars.discourse-cdn.com/v4/letter/j/4bbf92/32.png) [@josborn](https://forum.inductiveautomation.com/u/josborn)\ **Post date:** [October 21, 2021, 5:41pm UTC](https://forum.inductiveautomation.com/t/not-able-to-pull-the-data-after-1-pm/52114/5 "2021-10-21T17:41:32Z")
You could simplify things by utilizing the formatted value property of your date time input, that way you don’t need any custom properties or transforms. ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/f/1/f1b4bb41ba5d62d675096514ce37c23e7f046870.png) ---
**Author:** ![pkhoshroo](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pkhoshroo/32/26801_2.png) [@pkhoshroo](https://forum.inductiveautomation.com/u/pkhoshroo)\ **Post date:** [October 21, 2021, 5:42pm UTC](https://forum.inductiveautomation.com/t/not-able-to-pull-the-data-after-1-pm/52114/6 "2021-10-21T17:42:23Z")
That’s a very good point! Thank you!!!