i have date variable contains time:
dim dt date dt = "8/3/2016 7:10:40 am" --> remove somehow time result should be:
dt = "8/3/2016" my question how remove time?
thanks
for date type variable:
dt = datevalue(dt) or
dt = cdate(int(dt)) or string:
strdt = format$(dt, "m/d/yyyy")
Comments
Post a Comment