I ask this because in my code, I'm trying to "assemble"
a date from pieces which are gotten elsewhere in the program.
I want to do this:

Dim ThisDate as Date
ThisDate = "monthGottenElsewhere" & "/" & "dayGottenElsewhere" _
 & "/" & "yearGottenElsewhere"
 but I don't know the datatypes of the individual pieces.
... Or can you even do this ???

Other data types can be implicitly or explicitly (CDate) converted to a
date.

The answer to your question:
Converting the date parts you have into strings (use Cstr if they are
integers) and separating them with "/"'s as you're doing will produce a
string which then your code will convert into the number that can be
submitted to all date functions . . . (assuming your date parts are all
within appropriate ranges - otherwise you'll get a type mismatch error)

ThisDate = CDate( monthGottenElsewhere & "/" & dayGottenElsewhere _
  & "/" & yearGottenElsewhere)

This works for string months (i.e., "Jan", "January", "1", "01", etc.),
integer Months (i.e., 1, 2, 3)
And string/integer years.  I think this is because VB forces them to
StringVariants.
--
Steven Allyn Taylor

But "Down Under" I'm moved to ask whether your sample date 02/12/99 is
dd/mm/yy or mm/dd/yy?

Barry Evans
Canberra, Australia
----------------------------

What data types are the individual pieces of a
date data type ??
If I assign  02/12/99  as a date  data type
then is the "02" an Integer, a String, or a Long ?

I ask this because in my code, I'm trying to "assemble"
a date from pieces which are gotten elsewhere in the program.
I want to do this:

Dim ThisDate as Date
ThisDate = "monthGottenElsewhere" & "/" & "dayGottenElsewhere" _
& "/" & "yearGottenElsewhere"
but I don't know the datatypes of the individual pieces.
... Or can you even do this ???