index | search | no replies | posting guidelines | help login | register
Index » Products » ASP Report Wizard v2
search this forum:
:: How do I do # of days in stock? ::    show all messagesPost a New Message | Post a Reply
Jun 28 2005, 4:55 AM
 Re: How do I do # of days in stock?Post a Reply
 ghost

View this author's profile Send this author a private message Visit author's homepage

from: Washington, DC

In order to get the number of days in SQL Server, you need to use the DateDiff function as shown below:

[sql]DateDiff(dd,DateReceive,GetDate())[/sql]





-------------------------
Ghost
Pages: (1)   [1]

search this forum: