Getting # symbol as display in output

[l_palacios]

How can I display actual output in qv dashboard. It displayes # symbol instead of values.

[Anonymous · Accepted solution]

This can happen when the data is too long to display.  Try making your column wider.

[l_palacios]

Wow. I didn’t even think of doing that. Let me ask you this. The value is a date value that is getting populated. This is the output: 3/18/2013 0:00

How do I just display the date and exclude the 0:00?

Thank you so much for your help.

-Luch

[Anonymous]

in load script when creating the field use something like :

date ( floor ( [YourDate ] ) , 'M/DD/YYYY' )

[l_palacios]

Hi Bill,

I forgot to say thank you. This helped but I found a way to do in the document properties of the dashboard.

[Anonymous]

The best way of saying thank you is to mark answers as correct/helpful

BTW, you can also define date format on the object level.

One important note: when you use floor(YourDateField) function, you make the field shorter by removing the time part, hence saving noticeable amount of application size.