Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Calculated dimension date problem

=date([Fab Out Dt] + $(vDate)) .

I am able to generate date using this in calculated dimension in table...but as soon as I convert it in line chart i get numbers instead of date...


I have attached both chart and table image

table shows fine but as soon as I click on line chart it shows internal numbers. Is there a way to convert them to date on line chart?




4 Replies
Anonymous
Not applicable
Author

What is comming on your variable vDate?

I did this same test here (with the same calculated dimension) and it worked fine.

If possible, upload here your qvw.

Regards,

Gabriel

arsal_90
Creator III
Creator III

please upload your qvw

wernerprovelu
Partner - Contributor II
Partner - Contributor II

Hi Ria,

Can you try: =date([Fab Out Dt] + $(vDate),'M/D/YYYY')

Not applicable
Author

Thanks all!


I did below and it worked

Settings - Document Properties - tab Number. Select the date field and choose Date at the Number format settings