Convert to date in custom query

[Connor_Marment1]

I'm trying to create a custom query that will bring up documents where the date in a keyword is on or after 10/1/2015. The caveat is that the keyword type for whatever reason was setup as alpha instead of date so I need to convert it to date in the query. 

I can run this in SQL and get the results I want but I haven't been able to get the custom query to work correctly in OnBase (note I am not using aliases in the custom query).

select id.itemnum [Document ID], convert(varchar,hd.keyvaluechar,101) [Hire Date]
from hsi.itemdata id
inner join hsi.keyxitem112 k112
on k112.itemnum = id.itemnum
inner join hsi.keytable112 hd
on hd.keywordnum = k112.keywordnum
where id.itemtypenum = '750' and hd.keyvaluechar > '2015-10-01'

[Anthony_Farkas · Accepted solution]

It looks like you are most likely hitting the character limit in the from field. There is more information here and a workaround as well: www.onbase.com/.../31546

Josh's answer is the best workaround in my opinion.

Hope that helps.

[Connor_Marment1]

That did the trick. Thanks!