C# Tutorials and offshore development in India
    Tutorials   Resources   Forum   Reviews   Communities   Interview   Jobs   Projects   Training   Your Ad Here    
Silverlight Games | Mentor | Code Converter | Articles | Code Factory | Computer Jokes | Members | Peer Appraisal | IT Companies | Bookmarks | Polls | Revenue Sharing | Lobby | Gift Shop |


Prizes & Awards
My Profile



Active Members
TodayLast 7 Days more...




Forums » .NET » ASP.NET »

Undefined function convert in expression


Posted Date: 04 Nov 2009      Posted By: net      Member Level: Silver     Points: 1   Responses: 1



hi,

i am given today's date and i am filling number of days.
between today's date and number of days that closing date come automatically
my query:
"select convert(varchar,(DATEADD(day," + txtnodays.Text + ",GETDATE())),101) as days"

whether it is correct or wrong



Responses
Author: Praveen    04 Nov 2009Member Level: DiamondRating: 2 out of 52 out of 5     Points: 2

hi,

change your query like this


select (DATEDIFF(day,DateAdd(day,"+ txtnodays.Text +",getdate()),GETDATE())) as day



Post Reply
You must Sign In to post a response.
Next : Download
Previous : Stored Procedures
Return to Discussion Forum
Post New Message
Category: ASP.NET

Related Messages


dotNet Slackers

About Us    Contact Us    Privacy Policy    Terms Of Use