Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have 11 columns in table. Each column has millions of record and each record date format different to each others (in a column). How to get a single date format in all columns?
EX: Table.1
column1 colmn2 colomn3
MMDDYYYY DDMMYYYY YYYYDDMM
YYYYMMDD MMDDYYYY DDYYYYMM
I want output:
column1 column2 column3
DDMMYYYY DDMMYYYY DDMMYYYY
Hi,
check this thread for starters:
https://community.qlik.com/message/1158961#1158961
Just search on the community for date format conversion
Andy
May be set environment of qlikview as you required
Hi Narasaiah,
I also faced the same issue but solved by extracting the field using the below syntax
date(fieldname1,'MM/DD/YYYY')as fieldname1,
date(fieldname2,'MM/DD/YYYY')as fieldname2
and so on.............
or
In main tab,
SET DateFormat='MM/DD/YYYY';
I think this will help you