how to strip the time from the date.

[Anonymous]

Hi All,

Can someone please let me know how I can strip the time from the follow-up column. I have tried various options but no luck. File is attached.

I have tried the following.

date(floor(timestamp#([Follow-Up Date],'dd/mm/yyyy h:mm'))) as record_date,

time(frac (timestamp#([Follow-Up Date],'dd/mm/yyyy h:mm'))) as record_time

Very new to qlikview.

[sunny_talwar]

This seems to work...

SET DateFormat='DD/MM/YYYY';

Table:

LOAD [Follow-Up],

    Date

FROM

[..\..\Downloads\TimeStamp.csv]

(txt, codepage is 1252, embedded labels, delimiter is ' ', msq);

[Anonymous]

Thanks Sunny, But the problem I have is that the actual csv file has more columns. example below. The only way I can get rid off the time is to format the "Follow-up Date" column to "Date" before I load the data. I am trying to avoid the manual process of formatting the date every single time.