Force a date format in the script

[jgreen95]

I have a field that in the QVD is formatted as a DateTime (YYYY-MM-DD HH:mm:ss)

I only want it as a date in format DD/MM/YYYY

I am using this in the Script where i load the data and it seems to be completely ignored and is still showing in a date time format 

date([MASTER_CALANDER.SOM],'DD/MM/YYYY') as [MASTER_CALANDER.SOM]

[StarinieriG]

Hi,

I am not sure, but you could try to add floor before date

date(Floor([MASTER_CALANDER.SOM]),'DD/MM/YYYY') as [MASTER_CALANDER.SOM]

[Vegar]

Does Qlik recognize [MASTER_CALANDER.SOM] as a timestamp or is it just a string? If a string, then try this:

=date(floor(timestamp#([MASTER_CALANDER.SOM],'YYYY-MM-DD hh:mm:ss')),'DD/MM/YYYY' ) as [MASTER_CALANDER.SOM]