I have a question. how to change the type from Date to integer
is there any way to change the type?
---------------------------------------
It is my code:
If CInt(CStr(Now.AddDays(7))) > 31 Then
SQL = "INSERT INTO Topic VALUES ('" & Session("Number") & "', '" & txtTopic.Text & "', '" & BTDDL.SelectedItem.ToString & "', '" & txtDiscription.Text & "', 0, 0, 'no', 'no', '" & Now.Year & "/" & Now.Month & "/" & Now.Day & "', '" & Now.Hour & ":" & Now.Minute & "', 'Open', '" & Now.Year & "/" & Now.AddMonths(1) & "/" & Now.AddDays(-31) & "')"
End If
-----------------------------------
I know Date with the format (yyyy/mm/dd) cannot change to integer format
but "Now.AddDays(7)" : it is a number if use a label to display
Why cannot change the type
is there any way to change the type?
---------------------------------------
It is my code:
If CInt(CStr(Now.AddDays(7))) > 31 Then
SQL = "INSERT INTO Topic VALUES ('" & Session("Number") & "', '" & txtTopic.Text & "', '" & BTDDL.SelectedItem.ToString & "', '" & txtDiscription.Text & "', 0, 0, 'no', 'no', '" & Now.Year & "/" & Now.Month & "/" & Now.Day & "', '" & Now.Hour & ":" & Now.Minute & "', 'Open', '" & Now.Year & "/" & Now.AddMonths(1) & "/" & Now.AddDays(-31) & "')"
End If
-----------------------------------
I know Date with the format (yyyy/mm/dd) cannot change to integer format
but "Now.AddDays(7)" : it is a number if use a label to display
Why cannot change the type
