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?
If ddlMember.SelectedIndex = "2" Then
Dim Issudate As Date
Dim DueDate As Date
Issudate = Date.Now DueDate = Issudate.AddDays(14).ToShortDateString()
clscommon.executeNonQuery("insert into DAV_LIB_Book_Transaction(BM_ID,BT_Issue_Dt,BT_MemberType,BT_IssuedTo,BT_Actual_Return_Dt,Active) values ('" & Trim(StrConv(txtBkId.Text, VbStrConv.ProperCase, 0)) & "','" & dt & "','" & Trim(StrConv(txtMemberId.Text, VbStrConv.ProperCase, 0)) & "','" & ddlMember.SelectedValue & "','" & dt & "',1)")