Split Date

[Redth]

Hello
I've made it so in my app, the user selects the day, month and year from drop down menus... this works great for adding dates to the database.. however, when they pull up a record to edit, i'd like the date to go to that record's date.. so here's what im trying to do...

newdate() = split(thedate, "/")

i get an error doing that...

is there some special thing i need to do to the variable holding the date before splitting it? i declared the variable as a string b4 putting the date into it from the database (the database field isn't even a Date type field.. just normal varchar)....

the split function works nice for everything else .. help's appreciated!

[Skitchen8]

don't declare it as a string

[MartinLiss]

You shouldn't have any problem using strings. This works.

Dim newdate() As String
Dim thedate As String

thedate = "06/04/02"
newdate() = Split(thedate, "/")

Debug.Print newdate(0)
Debug.Print newdate(1)
Debug.Print newdate(2)

[Skitchen8]

oh sorry, my mistake... i didn't see the () after the declaration (if you don't have that it won't work right??)

[Edneeis]

Maybe I missed something but how is something like this:

newDateYear=Year(thedate)
newDateMonth=Month(thedate)
newDateDay=Day(thedate)
'or to join parts
thedate=DateSerial(newDateYear,newDateMonth,newDateDay)