topic Re: Reg: Date issue in QlikView

Reg: Date issue

Kohli — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Reg: Date issue

awhitfield — Wed, 22 Mar 2017 10:39:29 GMT

Hi,

check this thread for starters:

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

Just search on the community for date format conversion

Andy

Re: Reg: Date issue

Anil_Babu_Samineni — Wed, 22 Mar 2017 10:44:31 GMT

May be set environment of qlikview as you required

Re: Reg: Date issue

yoganantha321 — Wed, 22 Mar 2017 10:47:16 GMT

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.............

In main tab,

SET DateFormat='MM/DD/YYYY';

I think this will help you