I have a field of Issue date which takes the date of that very day when i fire the query now I want that field of Return Date in my data base should take the date while adding 14days to it?
How do i do that?
Mrinal1991
0
Newbie Poster
Recommended Answers
Jump to PostTry this,
Dim Issudate As Date Issudate = Date.Now MessageBox.Show(Issudate.AddDays(14).ToShortDateString())
Using Query
SELECT paper_date + 5 AS [Start + 5] FROM TableName
Hope this will help you...
Jump to PostJust add as,
Issudate=Issudate.AddDays(14).ToShortDateString()
now insert this variable to database
All 8 Replies
bhagawatshinde
11
Posting Whiz
Mrinal1991
0
Newbie Poster
bhagawatshinde
11
Posting Whiz
Mrinal1991
0
Newbie Poster
bhagawatshinde
11
Posting Whiz
Mrinal1991
0
Newbie Poster
bhagawatshinde
11
Posting Whiz
Mrinal1991
0
Newbie Poster
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.