<div>
Thanks Scott! That worked really well and the ORDER BY worked using the alias DueDate as well. <br />
<br />
It seems so simple :o) I really appreciate your help.<br />
<br />
Cheers,<br />
Brad
</div>


Thanks Scott! That worked really well and the ORDER BY worked using the alias DueDate as well.

It seems so simple :o) I really appreciate your help.

Cheers,
Brad

<div>
Your welcome, glad it worked for you and thanks for the grade<br />
<br />
Cheers<br />
<br />
Scott
</div>


Your welcome, glad it worked for you and thanks for the grade

Cheers

Scott

<div>
<div class="content wysiwyg-content">
Hi All,<br />
<br />
I'm having some trouble figuring out how to sort by a date which is not stored in the database but which is calculated on-the-fly on my webpage by adding a number of days to another date.<br />
<br />
So we have the following fields in the table UserDetails:<br />
<br />
Date (smalldatetime ('dd/mmyyyy')<br />
Term (int)<br />
<br />
I am trying to sort my results by DueDate (which is dynamically calculated and not stored as a field in the db) which is Date ('dd/mm/yyyy') + Term (number of days (int) ).<br />
<br />
So I am wondering if there is anyway that inside my SELECT in my SQL statement I can actually create a new date AS DueDate which is the above sum?<br />
<br />
Anyone have any ideas?<br />
<br />
Cheers,<br />
Brad
</div>
</div>


Hi All,

I'm having some trouble figuring out how to sort by a date which is not stored in the database but which is calculated on-the-fly on my webpage by adding a number of days to another date.

So we have the following fields in the table UserDetails:

Date (smalldatetime ('dd/mmyyyy')
Term (int)

I am trying to sort my results by DueDate (which is dynamically calculated and not stored as a field in the db) which is Date ('dd/mm/yyyy') + Term (number of days (int) ).

So I am wondering if there is anyway that inside my SELECT in my SQL statement I can actually create a new date AS DueDate which is the above sum?

Anyone have any ideas?

Cheers,
Brad

Adding days to a date then sorting by the new date

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.