What does SET DateFormat='M/D/YYYY'; in the data load editor script do?
I see that there is SET DateFormat='M/D/YYYY'; line the data load editor script -- I am curious to learn what it does? I had a hypothesis that it formats all fields (from the load section) with "date" datatype to M/D/YYYY format. But that doesn't seem to be true.
Re: What does SET DateFormat='M/D/YYYY'; in the data load editor script do?
It defaults the format used when you use Date() function. and if you data source has the same format as the one you set up top, QlikView will be able to recognize it as date and bring it as a date field instead of text.