November 17, 2011 at 2:34 pm
Yesterday I was able to create an expression within a Text Box to display the last day of the previous week formatted without the time.
Today I deleted that text box and I don't remember the syntax. :crazy:
Any help would be greatly appreciated.
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
November 17, 2011 at 2:53 pm
=DateAdd("d", -(WeekDay(Today(),2))+1, Today())
Displays the last day of last week.
11/12/2011 12:00:00:00 AM
How can I format it to omit the time?
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
November 17, 2011 at 5:45 pm
I remembered what I did.
Simply right click on the text box select properties and specify a date format.
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
November 17, 2011 at 5:56 pm
That's a lot more simple than the expression I use. So easy thanks for posting back.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
November 17, 2011 at 6:10 pm
SQLRNNR (11/17/2011)
That's a lot more simple than the expression I use. So easy thanks for posting back.
I'm glad that I remembered; I did not think I was going to get a respond.:-)
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
November 17, 2011 at 6:13 pm
Welsh Corgi (11/17/2011)
SQLRNNR (11/17/2011)
That's a lot more simple than the expression I use. So easy thanks for posting back.I'm glad that I remembered; I did not think I was going to get a response.:-)
It's all in the timing 😀 If you hadn't remembered it and replied back, I might not have seen this thread in the first place:cool::hehe:
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
November 18, 2011 at 5:20 am
I spoke too soon.:crying:
You can format the date in SSRS 2008 as I stated but that is not the case in 2005.
I'm posting a question to the Reporting Services Forum.
I found where to the format the text box. It is not as obvious as in 2008.
http://www.sqlservercentral.com/Forums/Topic1208250-150-1.aspx
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
November 18, 2011 at 5:32 am
You mean you can't go in the format property and do something like yyyy-MM-dd?
Viewing 8 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply