topic Julian Date in QlikView

Julian Date

Thu, 10 Nov 2011 13:53:45 GMT

Hi,

Anybody knows why the date is returing in julian date format even it is not Julian in the table..

I created a QVD file to pull up some fields from table X..

the DATE filed in the table is in YYYY-MM-DD which is what I need.

in the QVD file the DATE field still in the same format which is great too.

now when I use the Field in a report by loading it from the QVD file it returns the date in Julian Date format.!!

Anybody knows how to fix it?

Thanks!

swuehl — Thu, 10 Nov 2011 14:21:05 GMT

So you get something like 2455876 as today's date? That's quite strange.

If not, what do you mean with Julian date?

Maybe you just get the numerical date representation, so try a Date(DATEFIELD,'YYYY-MM-DD') to format it as date.

Regards,

Stefan

Thu, 10 Nov 2011 14:32:42 GMT

Thank you so much!