Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Date Format

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

4 Replies
prma7799
Master III
Master III

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

settu_periasamy
Master III
Master III

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

];

Not applicable
Author

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

[

Date,  Platform

10/1/2014, STAR

11/1/2014, STAR

];

senpradip007
Specialist III
Specialist III

Try like

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

Inline [

Date,                        Platform

10/1/2014,                   STAR

11/1/2014,                   STAR

];