# Alignment of Date data/format types **URL:** \ **Category:** Ignition\ **Created:** [July 14, 2023, 8:03pm UTC](https://forum.inductiveautomation.com/t/alignment-of-date-data-format-types/76409 "2023-07-14T20:03:31Z")\ **Posts on this page:** 2\ **Page:** 1
**Author:** ![Earl\_Jensen](https://avatars.discourse-cdn.com/v4/letter/e/a587f6/32.png) [@Earl\_Jensen](https://forum.inductiveautomation.com/u/Earl_Jensen)\ **Post date:** [July 14, 2023, 8:03pm UTC](https://forum.inductiveautomation.com/t/alignment-of-date-data-format-types/76409/1 "2023-07-14T20:03:31Z")
I'm building a report with a startTime and endTime and it works when I pull the dates from existing shift tags in ignition. However, I'm trying to pull the dates from report parameter list and mssql query freezes up. The query handles fine if I pull from shift tags, so I believe it has to do with date format in expressions vs date format in python/ignition. I can't find out how to correct and hoping someone can walk through data types. 🙂 I'm trying to pass in flexible dates through the parameters rather than pull from tags. ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/e/4/e41b763dc313579a0941b5a29a78f1b1037e944e.png) Heres' the two parameters in the report setup: ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/c/3/c30d88f39b99b4f22f41971f897a79de3f5fc3be.png) ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/0/3/03a716673fc1048e610dd14bbb17139d728b6290.png) Here's the CurrentShiftTimeStart tag that I pull that works in the query. End is setup the same way: ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/9/8/98595ba8a92176a189f36d415d2ad852c785c014.png) ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/0/1/01c74624d8697bbc07aebb2dcd22c918476f32ce.png) Heres' the named query call: ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/3/6/36b20269f21c67d5685ec174c491b81de094a767.png) MSSQL table that datetime format is. Not sure if this helps: ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/9/4/94dd840d18d2df79b5421414f16a687af45797bf.png) EDIT: When I say hung, I mean the connection to DB in gateway stays open much longer than it should (eventually times out) then my designer pops up this error and icon: ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/4/d/4d9523cb2c2b7e9d19dc2183a714ffb5e862c3c2.png) ```auto java.util.concurrent.ExecutionException: com.inductiveautomation.ignition.client.gateway_interface.GatewayException: Read timed out at java.base/java.util.concurrent.FutureTask.report(Unknown Source) at java.base/java.util.concurrent.FutureTask.get(Unknown Source) at java.desktop/javax.swing.SwingWorker.get(Unknown Source) at com.inductiveautomation.reporting.designer.workspace.design.SampleData$SampleDataLoader.done(SampleData.java:145) at java.desktop/javax.swing.SwingWorker$5.run(Unknown Source) at java.desktop/javax.swing.SwingWorker$DoSubmitAccumulativeRunnable.run(Unknown Source) at java.desktop/sun.swing.AccumulativeRunnable.run(Unknown Source) at java.desktop/javax.swing.SwingWorker$DoSubmitAccumulativeRunnable.actionPerformed(Unknown Source) at java.desktop/javax.swing.Timer.fireActionPerformed(Unknown Source) at java.desktop/javax.swing.Timer$DoPostEvent.run(Unknown Source) at java.desktop/java.awt.event.InvocationEvent.dispatch(Unknown Source) at java.desktop/java.awt.EventQueue.dispatchEventImpl(Unknown Source) at java.desktop/java.awt.EventQueue$4.run(Unknown Source) at java.desktop/java.awt.EventQueue$4.run(Unknown Source) at java.base/java.security.AccessController.doPrivileged(Native Method) at java.base/java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(Unknown Source) at java.desktop/java.awt.EventQueue.dispatchEvent(Unknown Source) at com.inductiveautomation.snap.swing.RibsEventQueue.dispatchEvent(RibsEventQueue.java:99) at java.desktop/java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source) at java.desktop/java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source) at java.desktop/java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source) at java.desktop/java.awt.EventDispatchThread.pumpEvents(Unknown Source) at java.desktop/java.awt.EventDispatchThread.pumpEvents(Unknown Source) at java.desktop/java.awt.EventDispatchThread.run(Unknown Source) Caused by: com.inductiveautomation.ignition.client.gateway_interface.GatewayException: Read timed out at com.inductiveautomation.ignition.client.gateway_interface.GatewayInterface.newGatewayException(GatewayInterface.java:351) at com.inductiveautomation.ignition.client.gateway_interface.GatewayInterface.getResponse(GatewayInterface.java:543) at com.inductiveautomation.ignition.client.gateway_interface.GatewayInterface.sendMessage(GatewayInterface.java:283) at com.inductiveautomation.ignition.client.gateway_interface.GatewayInterface.sendMessage(GatewayInterface.java:278) at com.inductiveautomation.ignition.client.gateway_interface.GatewayInterface.moduleInvokeSafe(GatewayInterface.java:908) at com.inductiveautomation.ignition.client.gateway_interface.ModuleRPCFactory$DynamicRPCHandler.invoke(ModuleRPCFactory.java:53) at com.sun.proxy.$Proxy63.getReportData(Unknown Source) at com.inductiveautomation.reporting.designer.workspace.design.SampleData$SampleDataLoader.doInBackground(SampleData.java:135) at com.inductiveautomation.reporting.designer.workspace.design.SampleData$SampleDataLoader.doInBackground(SampleData.java:112) at java.desktop/javax.swing.SwingWorker$1.call(Unknown Source) at java.base/java.util.concurrent.FutureTask.run(Unknown Source) at java.desktop/javax.swing.SwingWorker.run(Unknown Source) at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at java.base/java.lang.Thread.run(Unknown Source) Caused by: java.net.SocketTimeoutException: Read timed out at java.base/java.net.SocketInputStream.socketRead0(Native Method) at java.base/java.net.SocketInputStream.socketRead(Unknown Source) at java.base/java.net.SocketInputStream.read(Unknown Source) at java.base/java.net.SocketInputStream.read(Unknown Source) at java.base/java.io.BufferedInputStream.fill(Unknown Source) at java.base/java.io.BufferedInputStream.read1(Unknown Source) at java.base/java.io.BufferedInputStream.read(Unknown Source) at java.base/sun.net.www.http.HttpClient.parseHTTPHeader(Unknown Source) at java.base/sun.net.www.http.HttpClient.parseHTTP(Unknown Source) at java.base/sun.net.www.protocol.http.HttpURLConnection.getInputStream0(Unknown Source) at java.base/sun.net.www.protocol.http.HttpURLConnection.getInputStream(Unknown Source) at java.base/java.net.HttpURLConnection.getResponseCode(Unknown Source) at com.inductiveautomation.ignition.client.gateway_interface.GatewayInterface.getResponse(GatewayInterface.java:437) ... 13 more Ignition v8.1.17 (b2022051210) Java: Azul Systems, Inc. 11.0.15 ``` Thanks!! Earl ---
**Author:** ![ryan.white](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/ryan.white/32/73193_2.png) [@ryan.white](https://forum.inductiveautomation.com/u/ryan.white)\ **Post date:** [July 14, 2023, 8:34pm UTC](https://forum.inductiveautomation.com/t/alignment-of-date-data-format-types/76409/2 "2023-07-14T20:34:18Z")
Try adding a logger via `system.util.getLogger` and use that logger to log the reported type of the `startTime` and `endTime` variables. See if there is an actual difference between what is returned from the report parameters and the tags you are reading from. If they are both reporting the same type, then confirm that the expected report parameter values aren't causing issues with your query.