Date Format

[#1]

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

[prma7799]

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

[settu_periasamy]

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

];

[#4]

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]

Try like

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

Inline [

Date,                        Platform

10/1/2014,                   STAR

11/1/2014,                   STAR

];