i NEED ONLY DATE IN MY REPORT

Question

Post reply

i NEED ONLY DATE IN MY REPORT

sql_reporting

SSC Veteran

Points: 299
More actions
February 21, 2012 at 1:49 pm

#253340

when i run the report i see date and time in the column. but actually in the table it is only date but why i am getting time too. i am using sp but when i decalre variable also i declared it as date.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

ansuman2006 SSC Eights! Points: 987 More actions · Answer 1

right click on the textbox and select the textbox properties option

Number -> Date -> select the format in which you want to display.

sql_reporting SSC Veteran Points: 299 More actions · Answer 2

It was so simple i forgot to even look at it. Thank you.

LutzM SSC Guru Points: 107049 More actions · Answer 3

Edit: complaint no longer valid. Immediately fixed by the OP. Well done!

Lutz
A pessimist is an optimist with experience.

How to get fast answers to your question[/url]
How to post performance related questions[/url]
Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

sql_reporting SSC Veteran Points: 299 More actions · Answer 4

i have edited my posts thank you anyway for informing.

i NEED ONLY DATE IN MY REPORT

Cookies on SQLServerCentral