topic Re: Convert date format loaded from .txt file in QlikView

Convert date format loaded from .txt file

Tue, 25 Nov 2014 13:54:50 GMT

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

Re: Convert date format loaded from .txt file

Anonymous — Tue, 25 Nov 2014 13:57:56 GMT

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

Re: Convert date format loaded from .txt file

Frank_Hartmann — Tue, 25 Nov 2014 13:58:07 GMT

Try this

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

Re: Convert date format loaded from .txt file

Tue, 25 Nov 2014 14:28:12 GMT

Hi,

Load *,

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

From Table;