Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
KingCarlos
Yak Posting Veteran
74 Posts |
 Posted - 2009-09-27 : 23:57:03
|
| Any asssitance is really appreciated. I am building a report which has a due date value and a today value, this is an expression using the following =String.Format("{0:dd/MM/yyyy}", DateTime.Today)Now I want to find the difference between the duedate and todays date. How would I go about this?Therefore the Duedate = 27/09/2009 and todays date is 28/09/2009 therefore the difference is 1.I am guessing I have to put something in place because if the Duedate = 27/09/2009 and todays date is 28/11/2009 how does SQL know that September has 30 days and October has 31 days. |
|
|
|
|
|
Using DATEDIFF in SQL Report Builder 2.0