topic Re: converting into date in QlikView

converting into date

Wed, 25 Nov 2020 16:16:04 GMT

hi ,

the data i am loading has a date format like 20160705 and i need to change it to date format.

is there a way i can change in the load statement?

regards,

marvin

sunny_talwar — Tue, 23 Aug 2016 13:14:34 GMT

Yes you can, try this:

LOAD Date(Date#(DateField, 'YYYYMMDD'), 'MM/DD/YYYY') as DateField

....

Anonymous — Tue, 23 Aug 2016 13:14:46 GMT

use

date#(yourdatefield,'YYYYMMDD')

you can convert it to other dateformat (if not your Standard dateformat)

date(date#(yourdatefield,'YYYYMMDD'),'MM/DD/YYYY')

Anonymous — Tue, 23 Aug 2016 13:17:48 GMT

Please try :

Date(Floor(Date#(your_date_field, 'YYYYMMDD')), 'MM/DD/YYYY')

Tue, 23 Aug 2016 13:19:15 GMT

cool thanks i will give it a shot

Tue, 23 Aug 2016 13:25:29 GMT

The value gives me this 59097/08/16. it seems the year is in string?

florentina_doga — Tue, 23 Aug 2016 13:32:27 GMT

=date(MakeDate(left(data,4),mid(data,5,2),right(data,2)),'DD-MMM-YYYY')

Chanty4u — Tue, 23 Aug 2016 16:14:10 GMT

try below script with load

Format:

LOAD * INLINE [

dateformat

20160705

];

Result:

LOAD *,

Date(Date#(dateformat,'YYYYMMDD'),'MM-DD-YYYY') AS Newdate

Resident Format;