topic Convert field to date in QlikView

Convert field to date

CNH_1978 — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I am trying to convert a field to a date but i'm really struggling. Can anyone help with the attached please?

Its a number field but i just can't seem to get it displayed as a date in the format DD/MM/YYYY

Kushal_Chawda — Tue, 18 Aug 2020 15:14:45 GMT

you need num# here

num#(Date) as Date

eliran — Tue, 18 Aug 2020 15:18:16 GMT

Hi,

The part missing is below.

It doesnt recognize date as a date, since it got spaces after it, trimming did the trick.

NoConcatenate
Data_TMP1:
Load
Name,
trim(Date) as Date,
Data
Resident Data_1;
drop table Data_1;

CNH_1978 — Tue, 18 Aug 2020 15:28:05 GMT

Great stuff, thanks very much :