remove timestamp

[Rovinesh]

Hello experts,

I'm trying to make a performance report with charts. It mostly works, but on every x-axis, i use dates. When I run the report, it shows the Date with the timestamp like this: YYYY-MM-DD 00:00:00:00. When I format the date in Data Format, it doens's change. Can someone help me with this?

thanks in advance!

[HalfBloodPrince]

Try this. go to to format , in date format put pattern as YYYY/MM/DD

[Rovinesh]

sorry, that doesnt work either.

[HalfBloodPrince]

then  try this  cast([time stamp column],date)

[Rovinesh]

how do I use the cast function? i'm kinda new with this.

[sureshsugu]

Hi,
      You can change the date format to YYYY-MM-DD. if it is oracle use to_char([dataitem],'YYYY-MM-DD') . if it is SQL server use convert(varchar(10),[dataitem]). I hope it helps.

Thanks,
Suresh.

[Rovinesh]

Hi,

thank you all for your answers, but i cant seem to get it right.
What i am trying to do is create a chart, with at the x-axis using dataitem Date. When i run the report, i get YYYY-MM-DD 00:00:00:000. I cant remove the timestamp with data format. The answers given don't work with me as i get several errors when i try to validate the query. When I changed the Source Type in Properties from Member Caption to Data Item Value, it removes the timestamp, but the days are displayed as yeardays from 001 to 366.

Does anyone know how to solve this?

thanks in advance!!!!

[mtirpude]

Hi Rovinesh,

Can you connect me using Team viewer so that I can have a look at it and resolve it. This does not looks like a big issue.

Regards,
Manish | +919673990644
www.infocepts.com | mtirpude@infocepts.com

[Rovinesh]

Hi,

Thank you all for your help. It finally worked. I deleted the chart and made it again and it worked.
Again thanks for your help!!!!!!