topic Re: Convert Datetime to date in QlikView

Convert Datetime to date

nagarajupinnibo — Fri, 25 Apr 2014 09:00:35 GMT

Hi,

Actually datefield contains value as '2013-08-21T18:36:15'

But, I need only date as '2013-08-21'.

I used Date() function inside Load statement,but Iam not getting exact value..

I need to apply function inside Load statement..

Please provide the solution for it..

Thanks

Nagaraju

Re: Convert Datetime to date

Anonymous — Fri, 25 Apr 2014 09:07:50 GMT

If Date doesn't worked then you can try with Left(datefield,10)

Re: Convert Datetime to date

Fri, 25 Apr 2014 09:10:18 GMT

Try this

Date(Datefield,'yyyy-mm-dd') as newDate

Hope it will help

Re: Convert Datetime to date

maxgro — Fri, 25 Apr 2014 09:10:59 GMT

= date(date#(left('2013-08-21T18:36:15',10),'YYYY-MM-DD'), 'YYYY-MM-DD')

EDIT: in a load

LOAD

....

date(date#(left('2013-08-21T18:36:15',10),'YYYY-MM-DD'), 'YYYY-MM-DD') as newdatefield,

......

FROM

....

replace '2013-08-21T18:36:15' with the field

Re: Convert Datetime to date

MK_QSL — Fri, 25 Apr 2014 09:11:02 GMT

Use below in your script....

Date(Date#(Left(2013-08-21T18:36:15,,10),'YYYY-MM-DD')) as Date

Re: Convert Datetime to date

its_anandrjs — Fri, 25 Apr 2014 09:13:02 GMT

Use in load script like

Load

Date(Date#(Left('2013-08-21T18:36:15',10),'YYYY-MM-DD'), 'YYYY-MM-DD') as UpdatedDatefield,

Left(YourdateField,10) as NewDatefield

From Location;

Re: Convert Datetime to date

rustyfishbones — Fri, 25 Apr 2014 09:21:12 GMT

try

Re: Convert Datetime to date

nagarajupinnibo — Fri, 25 Apr 2014 10:28:18 GMT

Thanks to all.. Now,Its working fine.

Thanks

Nagaraju

Re: Convert Datetime to date

its_anandrjs — Fri, 25 Apr 2014 10:30:06 GMT

If you got correct answer from thread so mark Correct / Helpful for reference.

Regards