-
I have code that combines the text of two text boxes. It is a date and time combination. For example
dateplus = cdate(startdate.text & " " & stopdate.text, "mmddyyhhnn")
now I want to break this back down to just the time to compare to another time. I need to use the time the dateplus value has accumulated and not the original time.
In other words I need to break down and get just the time out of the date plus value in order to set a condition of it is is greater than cdate("9:59pm")
Suggestions?
-
onlytime = cdate(dateplus, "hhnn")
???????
PH
-
This did not work. we received a compile error. The compiler wants Cdate(expression) as date.
Any other ideas?
-
To combine Date and Time Text:
dCombined = CDate(txtDate & " " & txtTime)
Time Part..
sTime = Format(dCombined, "HH:NN AMPM")
Date Part..
sDate = Format(dCombined, "MM/DD/YYYY")
------------------
Aaron Young
Analyst Programmer
[email protected]
[email protected]
