In your load do simply this:
DATE(FLOOR([date import])) AS [date import],
Keep in mind that Date(Floor(timestampDate)) will transform the time of the timestamp to 00:00:00. Maybe if you use
date(right([date import], 10), 'DD/MM/YYYY') as [date import]
in a preceding LOAD you'll get what you want Or if you want everything in the same expression do as follow:
date(right( DATE(FLOOR([date import])) , 10), 'DD/MM/YYYY') as [date import]
I tried your solution in the script and also in my dimension but I still have the problem during conversion to powerpoint. Looks like Qlik isn't taking into acount my date format but using a specific setting during conversion.
Is there a member from Qlik Staff that can tell if this is a known bug? Or if there is a solution ?
thanks for your help!