Date Format Issue

[satishkurra]

Hi

I'm using the below script to load the date in M/D/YYYY format.

My source is in a different format (YYYYMMDD)

After reloading i'm able to get the Sales as $100, But the date format is still YYYYMMDD.

Can someone help me to resolve this.

Am i missing something here?

Temp:

LOAD

Date(0, 'M/D/YYYY') as Date,

Num(0, '$#,##0') as Sales

AutoGenerate 0;

Sales:

LOAD * Inline [

ID,Date,Sales

1,20151201,100 ];

DROP Table Temp;

[satishkurra]

Can someone respond to this?

[rwunderlich]

maxgro‌ is correct. The technique you are referring to in my blog post is for assigning a display format to a field, not interpreting input. Those are two different things.

-Rob