This is my scrip below, where would I place your recommendation scrip?
I have also did screen shots of the Model, the date format in the Model is correct, but when I export the data to excel, csv, it exports in the date format as dd-mmm. This only happens when I export for many records of data. I have read the "Wrong date format when export to Excel" stream no soluton cn be derived from this one so as the one from Piet Hein van der Stigchel.
FOR EACH vSheet IN '[Secondary FY14]','[Secondary FY15]','[Secondary FY16]','[Secondary FY17]','[Primary FY14]','[Primary FY15]','[Primary FY16]','[Primary FY17]'
[SSD Suppliers_Primary Wholesalers],
[SSD Customer Name_Primary Ship-to],
[Self Care Territory],
[RX RSM Region],
[Self Care RSM Region],
[SSD Adj Value (SEP)],
[C:\Users\P00049057\Documents\JIVESH SINGH\Qlikview\Primary & SSD\Primary & SSD - Incl. Territories v2.xlsx]
(ooxml, embedded labels, table is $(vSheet));