asked on

Help with outlook form

I have a custom Meeting Form that I am creating for use in Outlook 2010. The problem I am having is when I create the Date Picker and Time Picker, and then pulling the values together as a date.

Attached is the code I am trying to get working.

Here is how the Start and End names are defined:

The field End on appointments is named txtEndTime

The field Start on appointments is named txtStartTime

I have experimented with MsgBox varType(variable here) and get a return of 7 which I want. This all changes though when I try to combine the date and time into one field like Start. It then returns a variable of 8 which means a string.

Any help greatly appreciated!
My script.

formscript.txt

ASKER CERTIFIED SOLUTION

aikimark

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

jriver12

ASKER

give me a bit to add your suggestions and test. also will compose the relationships.

thanks.

jriver12

ASKER

I am still having the issue, but have isolated it to be On submit states invalid date. Further investigating shows the combined value is a string and not a date, even when I use CDate when trying to put together the time and date fields. ie timefiled = 12:00:00 and date field = 06/06/2012, cdate would = timefield datefield.

aikimark

there needs to be a space character between them when fed into the CDate() function.

You can also use the TimeSerial() function to create the time component and add it to your date variable.

jriver12

ASKER

will test and let you know.