Frank Tanner III
pctech at mybellybutton.com
Mon May 12 14:19:14 CDT 2003
And now for today's stupid question.... I am using Microsoft's DateTimePicker ActiveX control, because I am mot skilled enough to code my own caledaring and time system, and am running into some problems. I have one DTP (date time picker) in Calendar mode for start date, and one in clock mode for start time. I also have one for end date and time as well. Due to a limitation of the ActiveX components, I cannot directly access the info from my query, so I have to fill out "invisible" text boxes with the info. Now comes the problem.... The field I am comparing to is a datetime field in the following format: mm-dd hh:mm:ss. I am having no luck converting the two seperate date and time fields into a single field in order to compare it to this datetime field. Does anyone have any ideas on how I can do this? Any assistance you can give would be greatly appreciated.