There are 7 date fields with format '2020-10-29T00:00:00.000Z' and need to store these 7 date fields in QVD in format M/DD/YYYY (10/29/2020). I have tried below options at script level and stored the result in QVD but when I am loading QVD date format is lost. Expected output is (10/29/2020) and in QVD I am getting (2020-10-29T00:00:00.000Z).
I have tried below options but nothing is working. DATE(nextdate,'M/DD/YYYY') as nextdate, Date(Floor(nextdate)) as nextdate, DATE(timestamp#(nextdate,'M/D/YYYY h:mm:ss TT')) as nextdate,
NOTE: Above mentioned options are working at UI level but not when I am storing in QVD with M/DD/YYYY format.
