Discussion Board for collaboration related to QlikView App Development.
Hey guys i am loading data from a .txt file. can you please tell me how to change the date format of the in qlikview as QV is not converting not changing the format to DD/MM/YYYY as my setting is SET DateFormat='DD/MM/YYYY'
Member ID Member Name Date of Joining
M9004851 Amit 10-Mar-13
M9004855 Asit 04-Aug-14
M9005368 Ashish 02-Apr-11
M9004789 Praveen 15-Mar-11
M1045781 Vivek 09-Aug-13
M9007846 Sujeeth 07-Jul-13
M9007896 Balram 25-Sep-11
Date(Date#([Date of Joining], 'DD-MMM-YY'),'DD/MM/YYYY') AS [Date of Joining]
View solution in original post
date ( date # ( [Date of Joining] , 'DD-MMM-YY' ,'DD/MM/YYYY' )
Date ( Date # ( [Date of Joining] , 'DD-MMM-YY' ),'DD/MM/YYYY' ) as [Date of Joining]