Load date with pre-defined date functions

[eddyg]

When I load data from CSV file, a date field is recognized with Applied Calendars: autoCalendar. This allows to have the option to pick one of the pre-defined date functions on the field such as Year, Quarter, Month, YearMonth...

However, when I load data through load editor, a date field is not recognized as a date and the pre-defined date functions do not appear for it. 

In the data I load, the date format is yyyy-mm-dd.

I tried in my load editor script to force the conversion to date but Qlik still not recognizing the field as date (no pre-defined date functions):

Date(Date#(date,'yyyy-mm-dd'),'yyyy-mm-dd')

[vinieme12]

Try adding below at the end of the script

Tag Field   <FIELDNAME>  With $date

[Lech_Miszkiewicz · Accepted solution]

This article explains how derived fields work. Date fields must be tagged as $date prior to that part of script run

How to create on your own an Autocalendar (Derived... - Qlik Community - 1716542