topic Re: Date Format in QlikView

Date Format

Wed, 08 Jul 2015 04:15:29 GMT

Hi All ,

I have a two columns

Date Platform

10/1/2014 STAR

11/1/2014 STAR

When i concatenate both Columns and Load its displayed as

41913STAR

But my expected output should be as MM/DD/YYYYSTAR

Re: Date Format

prma7799 — Wed, 08 Jul 2015 04:26:38 GMT

Use =Date(yourfield,'MM/DD/YYYY')

Re: Date Format

settu_periasamy — Wed, 08 Jul 2015 04:55:48 GMT

Hi,

Try like this

Load *,Date(Date,'MM/DD/YYYY')&Platform as Key;

LOAD * INLINE [

Date,Platform

10/1/2014,STAR

11/1/2014,STAR

];

Re: Date Format

Wed, 08 Jul 2015 05:08:03 GMT

load date(date#(Date,'MM/DD/YYYY'),'MM/DD/YYYY') &Platform as key inline

[

Date, Platform

10/1/2014, STAR

11/1/2014, STAR

];

Re: Date Format

senpradip007 — Wed, 08 Jul 2015 05:17:48 GMT

Try like

LOAD *, Date#(Date, 'DD/M/YYYY')&Platform as Key

Inline [

Date, Platform

10/1/2014, STAR

11/1/2014, STAR

];