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

issues importing salesforce timestamp format into QlikView

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

1 Reply
Not applicable
Author

Hi!

Try something like below:

Test:

Load Distinct (ClosedDate)

resident TableClosedDate;

By Rebeca