issues importing salesforce timestamp format into QlikView

[#1]

Hi QlikView Community,

I have issues using load in connection with the salesforce connector.

After having successfully loaded the "ClosedDate" the format looks in QlikView like this: "DD.MM.YYY hh:mm".

I would like to get this date format: "DD.MM.YYY" (without hh:mm)

I´ve already tried  this in the load statement (before select):

Date(Date#(Mid(ClosedDate,1,10),'YYYY-MM-DD'),'DD.MM.YYYY') as ClosedDate2,

Date(Date#(Mid(ClosedDate,1,10),'YYYY-MM-DD'),'DD.MM.YYYY') as ClosedDate2,

and what I get looks ok: "DD.MM.YYYY" but it is not because QlikView does not shows unique dates. I would like to get every day only one time and not several times:

Can someone help?

Thanks in advance for your answer!

David

[#2]

Hi!

Try something like below:

Test:

Load Distinct (ClosedDate)

resident TableClosedDate;

By Rebeca