topic Re: conversion of date in QlikView

conversion of date

Thu, 26 Jun 2014 11:42:24 GMT

Hi Community,

I tried to change my date field from string to number.not able to resolve

please help me

Re: conversion of date

MK_QSL — Thu, 26 Jun 2014 11:48:01 GMT

=Date(Date#(date,'DD-M-YYYY'))

and

=NUM(Date(Date#(date,'DD-M-YYYY')))

Re: conversion of date

ashfaq_haseeb — Thu, 26 Jun 2014 11:50:49 GMT

try below

Alt( Date(Date#( [date] , 'DD-MM-YYYY' ),'DD-MM-YYYY'),

Date(Date#( [date] , 'DD-M-YYYY'),'DD-MM-YYYY')) AS NewDate,

Regards

ASHFAQ

Re: conversion of date

suzel404 — Thu, 26 Jun 2014 11:53:06 GMT

Attachement!

Re: conversion of date

Thu, 26 Jun 2014 11:53:28 GMT

= date(date#(date,'ddmmyyyy'))

Re: conversion of date

Thu, 26 Jun 2014 12:15:55 GMT

i want to dervie month and year fields how can i get that?

Re: conversion of date

tresB — Thu, 26 Jun 2014 12:19:11 GMT

Date(num(Date#([date] ,'DD-MM-YYYY')),'DD-MM-YYYY') as new_date,

can be written in an easier way like:

Date(Date#([date] ,'DD-MM-YYYY'),'DD-MM-YYYY') as new_date,

Month(Date#([date] ,'DD-MM-YYYY')) as new_Month,

Year(Date#([date] ,'DD-MM-YYYY')) as new_Year,

Re: conversion of date

Thu, 26 Jun 2014 12:20:56 GMT

year(= date(date#(date,'ddmmyyyy'))) as year,

month(= date(date#(date,'ddmmyyyy'))) as month

Re: conversion of date

ashfaq_haseeb — Thu, 26 Jun 2014 12:21:21 GMT

Like this.

LOAD cust_id,

date,

Date(Date#(date,'DD-MM-YYYY')) as Date,

Month(Date#(date,'DD-MM-YYYY')) as Month,

Year(Date#(date,'DD-MM-YYYY')) as Year,

sale

From

practice.xlsx

(ooxml, embedded labels, table is Sheet1);

Regards

ASHFAQ

Re: conversion of date

its_anandrjs — Thu, 26 Jun 2014 12:28:35 GMT

Hi Sruti,

Some of the very simple way try this load script for date, month and year

LOAD cust_id,

date,

Date(Date#(date,'DD-MM-YYYY')) as Date,

Month(Date#(date,'DD-MM-YYYY')) as Month,

Year(Date#(date,'DD-MM-YYYY')) as Year,

sale,

Date(Date#("date",'DD-M-YYYY')) as NewDate,

Year(Date(Date#("date",'DD-M-YYYY'))) as NewYear,

MOnth(Date(Date#("date",'DD-M-YYYY'))) as NewMonth

From

practice.xlsx

(ooxml, embedded labels, table is Sheet1);