Date field in Qlik Sense not supporting when extraction from SAP BW

[vamsee]

Hi,

Have you tried re-formatting the date field while loading the data?

Try 

Date(Date#(CREATEDON, 'MM.DD.YYYY')) as CREATEDON

Also try 

Num(Date#(CREATEDON, 'MM.DD.YYYY'))

and see if you are getting a number value for the dates

[vamsee]

Can you share the data with just two columns Rowno and Date field without any formatting, something like 

Source:
Load 
RowNo() as RowId,
DateField;
SQL * From Source;
Store Source into Source.qvd (qvd);

[vamsee]

Was just checking my SAP source and noticed that DATS field is always in YYYYYMMDD format.

Try that just in case 

Date(Date#(CREATEDON, 'YYYYMMDD')) as CREATEDON

[Arindam_Ghoshal_13 · Accepted solution]

Hi @vamsee ,

The Material codes were having Duplicate values

00000MatCode --having Date values
MatCode  -- Not having Date values

I was searching Matcodes(40*) as I assumed inital 0s were eliminated by Qlik.

Thanks for the reponse.