How to Delete Time in date field when the script was loaded from .csv file

[#1]

Hi i have a script which was loaded from .csv and in that file there is a field called date(02-02-2015 monday 8:53) in this format but i want the date field to display only date like 02-02-2015 when i pulled in to qlik how do do it can any one please tell,

Thanks in advance

[settu_periasamy]

Hi,

Try this..

Date(Date#(Left('02-02-2015 monday 8:53',10),'DD-MM-YYYY')) as Date

Note: I just assumed your format is 'DD-MM-YYYY', you can modify the format based on your data.

[jagan]

Hi,

Try like this

LOAD

*,

Date(Floor(DateFieldName)) AS Date

FROM Datasource;

Regards,

jagan.

[avinashelite]

if the format is fixed you can also try like this

Date(subfield(date,' ',1),'DD_MM_YYYY') as date

or

Date(Date#(subfield(date,' ',1)),'DD_MM_YYYY') as date