topic Re: Number to Date Format in QlikView

Number to Date Format

Thu, 19 Dec 2013 07:06:40 GMT

Hi All,

I have extracted data from QV into an CSV file, however the date filed got converted into number format where the export of data happened.

Now I have imported the same CSV into my QV application and the number format is still the same. I am not able to convert it into date format back

The format is as follows:

41275

41276

41277

41278

41279

41280

Required format is :

1-Jan-2013

2-Jan-2013

and so on

Need your assistance.

Re: Number to Date Format

sujeetsingh — Thu, 19 Dec 2013 07:10:43 GMT

try usind Date#() function or paste a sample

Re: Number to Date Format

jagan — Thu, 19 Dec 2013 07:12:29 GMT

Hi Hitesh,

Try like this

Date(DaetDimensionName, 'D-MMM-YYYY') AS Date

Regards,

Jagan.

Re: Number to Date Format

Gysbert_Wassenaar — Thu, 19 Dec 2013 07:12:37 GMT

Use the date() function:

date(MyDate, 'D-MMM-YYYY')

date(41275, 'D-MMM-YYYY')

Re: Number to Date Format

sujeetsingh — Thu, 19 Dec 2013 07:14:04 GMT

One thing to do is just open that csv and in date field column right click>>Format Cell>>>and select Date type value

Re: Number to Date Format

saumyashah90 — Thu, 19 Dec 2013 07:14:26 GMT

Hi Hitesh,

Try this
Date(FieldName,'DD-MMM-YYYY') as DateField

Re: Number to Date Format

Thu, 19 Dec 2013 07:14:31 GMT

Unit	41306	41275	41334	41315
a	1	1	1	11
b	1	1	7	10
c	1	1	7	53

I have used crosstable here, In the list box I am using this date field

Under the expression of list box, I have used : Date#(Duration, 'dd-mmm-yy'). I even tired Num (Date#(Duration, 'dd-mmm-yy'))

Re: Number to Date Format

Anonymous — Thu, 19 Dec 2013 07:21:13 GMT

no need to parse a date which is already parse using Date#

just use

Date(yourdatefield) as newdate

i used the following code in script and works fine.

LOAD Date(Date) as newdate

FROM

C:\Users\Anant\Desktop\anant.csv

(txt, codepage is 1252, embedded labels, delimiter is '\t', msq);

anant

Re: Number to Date Format

jagan — Thu, 19 Dec 2013 07:39:01 GMT

HI,

Try like this

Date(Duration, 'DD-MMM-YY')

No need to use Date#().

Regards,

Jagan.