Reg: Date issue

[Kohli]

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

[awhitfield]

Hi,

check this thread for starters:

https://community.qlik.com/message/1158961#1158961

Just search on the community for date format conversion

Andy

[Anil_Babu_Samineni]

May be set environment of qlikview as you required

[yoganantha321]

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