Qlik Community

Ask a Question

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Welcome to our newly redesigned Qlik Community! Read our blog to learn about all the new updates: READ BLOG and REPORTED ISSUES
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
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

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

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

Hi,

Load *,

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

From Table;