Convert date format loaded from .txt file

[#1]

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

[Anonymous]

date ( date # ( [Date of Joining] , 'DD-MMM-YY' ,'DD/MM/YYYY' )

[Frank_Hartmann · Accepted solution]

Try this

Date(Date#([Date of Joining], 'DD-MMM-YY'),'DD/MM/YYYY') AS [Date of Joining]

[#4]

Hi,

Load *,

Date ( Date # ( [Date of Joining] , 'DD-MMM-YY' ),'DD/MM/YYYY' ) as [Date of Joining]

From Table;