i only used varchar(MAX)
as I've said above, when the time i left txtShipoutDateActual.Text empty, i got an error.
"Conversion from string "" to type 'Date' is not valid."
because all the input value of txtShipoutDateActual.Text i convert it into Dayvalue.
here is my code:
-
Dim dateValueSDA As Date
-
dateValueSDA = txtShipoutDateActual.Text
-
lblDaysda.Text = WeekdayName(Weekday(dateValueSDA))
-
How can i code that into a conditional statement if txtShipoutDateActual.Text is null value, and lblDaysda.Text should also null value to save in database.