Date field not recognised

[#1]

I'm creating a field using this line:

NATIVE('CONVERT(DATE, ActivityDate)') AS Date

and I changed my format settings as

SET DateFormat='YYYY-MM-DD';

SET TimestampFormat='YYYY-MM-DD hh:mm:ss[.fff]';

but when creating visuatlisations the Date dimension is not recognised.

(I'm trying to build a parameter with relative dates ie. last 7 days etc.)

[Gysbert_Wassenaar]

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.