topic Re: Convert to date time in QlikView

Convert to date time

mhamurcuoglu — Fri, 10 Apr 2015 08:13:33 GMT

How convert nvarchar to date/time format

my format 20141210 1217 I want 10/12/2014 12:17

I m sorry for my English

Thanks

Re: Convert to date time

mrossoit — Fri, 10 Apr 2015 09:00:30 GMT

=date(date#('20141210 1217', 'YYYYMMDD HHmm'), 'DD/MM/YYYY HH.mm')

Re: Convert to date time

ankitaag — Fri, 10 Apr 2015 09:02:33 GMT

Hello Mehmet,

Try this:

=Date(Date#('20141210 1217','YYYYMMDD hhmm'),'DD/MM/YYYY hh:mm')

This will give you the result as: 10/12/2014 12:17

Thanks and Regards,

Ankita

Re: Convert to date time

rajkumarb — Fri, 10 Apr 2015 09:07:43 GMT

Use Previous said methods by Massimilliano & Ankita

Go through this Document It Is Very Helpfull

Re: Convert to date time

Fri, 10 Apr 2015 09:07:54 GMT

hi,

use date function for this.date(date#('20141210 1217'), 'DD/MM/YYYY HH.mm')

if date function is not working then use makedate()

Date=20141210 1217

date(makedate(left(Date,4),mid(Date,5,2),mid(Date,7,2)),'DD/MM/YYYY') as Date,

maketime(mid(Date,11,2),mid(Date,13,2) as time ----(hh:mm) formate

Regards

Vimlesh

Re: Convert to date time

jagan — Fri, 10 Apr 2015 09:08:41 GMT

Hi,

Try like this

=Timestamp(Timestamp#('20141210 1217', 'YYYYMMDD hhmm'), 'DD/MM/YYYY hh:mm')

Hope this helps you.

Regards,

jagan.

Re: Convert to date time

PrashantSangle — Fri, 10 Apr 2015 09:10:30 GMT

Hi,

You can use timestamp() and timestamp#()

try

=timestamp(timestamp#(DatefieldName,'YYYYMMDD hhmm'),'DD/MM/YYYY hh:mm')

Regards

Re: Convert to date time

nagarjuna_kotha — Fri, 10 Apr 2015 09:15:08 GMT

Hi,

try this .I Hope this will work.

=Timestamp(Timestamp#('20141210 1217', 'YYYYMMDD hhmm'), 'DD/MM/YYYY hh:mm')

Regards,

Nagarjuna