Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Support Cases coming to Qlik Community Oct. 4! Start chats, open cases, explore resources: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Convert date format loaded from .txt file

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

1 Solution

Accepted Solutions
Frank_Hartmann
Master II
Master II

Try this

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

View solution in original post

3 Replies
bill_markham
Champion III
Champion III

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

Frank_Hartmann
Master II
Master II

Try this

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

View solution in original post

Not applicable
Author

Hi,

Load *,

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

From Table;