Julian Date

[#1]

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 · Accepted solution]

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

[#3]

Thank you so much!