Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
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
Highlighted

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

Highlighted
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

Highlighted
Not applicable

Hi,

Load *,

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

From Table;