• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 257
  • Last Modified:

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
0
jriver12
Asked:
jriver12
  • 3
  • 2
1 Solution
 
aikimarkCommented:
1. Add Option Explicit to the General Declarations section
2. It might be helpful if you used specific data types for your variables.
3. Please explain the relationship/use of these controls:
txtStartTime and tmeStartTime
txtEndTime and tmeEndTime
0
 
jriver12Author Commented:
give me a bit to add your suggestions and test. also will compose the relationships.

thanks.
0
 
jriver12Author Commented:
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.
0
 
aikimarkCommented:
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.
0
 
jriver12Author Commented:
will test and let you know.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Ruby Fundamentals

This course will introduce you to Ruby, as well as teach you about classes, methods, variables, data structures, loops, enumerable methods, and finishing touches.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now