topic Re: Date field not recognised in QlikView https://community.qlik.com/t5/QlikView/Date-field-not-recognised/m-p/1036829#M933079 <HTML><HEAD></HEAD><BODY><P>Neither NATIVE nor CONVERT are Qlikview functions. If you're using them in an sql statement then you have to make sure your source database supports those functions.</P></BODY></HTML> Mon, 29 Feb 2016 17:02:46 GMT Gysbert_Wassenaar 2016-02-29T17:02:46Z Date field not recognised https://community.qlik.com/t5/QlikView/Date-field-not-recognised/m-p/1036828#M933078 <HTML><HEAD></HEAD><BODY><P>I'm creating a field using this line: </P><P></P><P>NATIVE('CONVERT(DATE, ActivityDate)') AS Date</P><P></P><P>and I changed my format settings as</P><P></P><P>SET DateFormat='YYYY-MM-DD';</P><P>SET TimestampFormat='YYYY-MM-DD hh:mm:ss[.fff]';</P><P></P><P>but when creating visuatlisations the Date dimension is not recognised. </P><P></P><P>(I'm trying to build a parameter with relative dates ie. last 7 days etc.)</P></BODY></HTML> Fri, 26 Feb 2016 13:04:27 GMT https://community.qlik.com/t5/QlikView/Date-field-not-recognised/m-p/1036828#M933078 2016-02-26T13:04:27Z Re: Date field not recognised https://community.qlik.com/t5/QlikView/Date-field-not-recognised/m-p/1036829#M933079 <HTML><HEAD></HEAD><BODY><P>Neither NATIVE nor CONVERT are Qlikview functions. If you're using them in an sql statement then you have to make sure your source database supports those functions.</P></BODY></HTML> Mon, 29 Feb 2016 17:02:46 GMT https://community.qlik.com/t5/QlikView/Date-field-not-recognised/m-p/1036829#M933079 Gysbert_Wassenaar 2016-02-29T17:02:46Z