Skip to Content
0
Sep 13, 2023 at 01:26 PM

Time in a Query

52 Views

Hi,

I have a UDF called ImportTime, its type is Date/Time and the structure is Hour.

If I add the field to a query, it comes out as 3:35PM which is the same value on the sales order screen in the field.

However when I setup a widget and reference the query when it runs its showing 1535.

Is there a fix I can do for this?