Number to Date Format

[#1]

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.

[sujeetsingh]

try usind Date#() function or paste a sample

[jagan]

Hi Hitesh,

Try like this

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

Regards,

Jagan.

[Gysbert_Wassenaar]

Use the date() function:

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

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

[sujeetsingh]

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

[saumyashah90]

Hi Hitesh,

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

[#7]

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'))

[Anonymous]

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

[jagan]

HI,

Try like this

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

No need to use Date#().

Regards,

Jagan.