Hi All,
Please help on below scenario .
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.
