Query Builder - date filter.
SQL Server
JMP version 16.2
In the database (SQL Server) I get the Date field called RETURNDATE in ‘varchar20’ – I would like to use the Calendar functionality in the filter to select my dates
![HansD_0-1643119365032.png HansD_0-1643119365032.png](https://community.jmp.com/t5/image/serverpage/image-id/39289i0676A6A239968E22/image-size/medium?v=v2&px=400)
I tried to create a calculated column (Calc1) and specify CAST([RETURNDATE] as date), which he doesn’t like.
![HansD_1-1643119365033.png HansD_1-1643119365033.png](https://community.jmp.com/t5/image/serverpage/image-id/39290i2C1FF04E31399896/image-size/medium?v=v2&px=400)
Using SQL outside Query Builder
SELECT TOP (1000) [LABJOBNO]
,[DESPATCHNO]
,CAST([RETURNDATE] as date) as CRETURNDATE
…
No problem
Using
Open Database( in JMP JSL with
WHERE ( CONVERT(DATE, DESPATCHRETURN.RETURNDATE, 106) between '01/01/2019' AND '12/31/2019')
Also no problem
Query builder doesn’t allow the entering of the quoted date string in the filter
Any advice?
Hans