Date format Issue in QVD to Dashboard

[jitu2110]

Hi Team,

i have a QVD file which have a Date Field name as "Trade Date".

when we are loading from QVD in snapshot Screen the "Trade Date" Columns show proper format value as "MM/DD/YYYY".

but after loading the Data in Dashboard it showing numeric value of "Trade Date". but actually in QVD it is showing Date proper format.

if  we explicitly formatting "Trade Date" to Date format by Date() in LOAD Statement then i am losing my QVD load Optimization.

Kindly let me know what needs to done

Thanks

Jitendra

[MK_QSL]

Make sure that when you create this field before generating or storing in QVD, you use Date() function.

So something like

Date([Trade Date])  as [Trade Date]

Now store the QVD and use it.

[thevingo]

Hi

try format Trade Date in dashboard

or

do you change default date format SET DateFormat='M/D/YYYY';

I doubt that Trade Date in QVD may be stored as text, just check.

[olivierrobin]

hello

the date is internamy stored as a number

load it this way

in your graph, use the function date() or use number/format/date in grpah properties to disply it the way you want