Date picker does not recognized my sql dimension "Date"

[cmutombo]

Hi ,

I need to use "Date picker" on one my sql dimension below. But, Is not working : 

SELECT to_char(SORDER.CREDATTIM_0,'dd/mm/YY HH24:MI') as CREDATE

some one can help me with syntaxe or Tip ?

[abhijitnalekar]

Hi @cmutombo ,

Are you looking this into Qlikview or in Qkiksense? 

I had this doubt as date peeker object is used in qliksense and this post is under