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

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

Tue, 02 Feb 2016 23:46:03 GMT

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

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

settu_periasamy — Wed, 03 Feb 2016 05:49:27 GMT

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.

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

jagan — Wed, 03 Feb 2016 05:54:57 GMT

Hi,

Try like this

LOAD

Date(Floor(DateFieldName)) AS Date

FROM Datasource;

Regards,

jagan.

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

avinashelite — Wed, 03 Feb 2016 05:55:15 GMT

if the format is fixed you can also try like this

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

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