Date and Time

[hbarker]

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?

[PietHein]

onlytime = cdate(dateplus, "hhnn")

???????

PH

[hbarker]

This did not work. we received a compile error. The compiler wants Cdate(expression) as date.

Any other ideas?

[Aaron Young]

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
aarony@redwingsoftware.com
adyoung@win.bright.net