SOLVED - How to deconstruct a date?

[admin12]

In the database, the three controls used to make the date of birth are separated out - they are drop down controls.

My database only has one field dedicated to the DOB, so I added them together like so:

put the text of field "MonthEntry" &space & the text of field "DayEntry" &comma & space & the text of field "YearEntry" into DOB

DOB is now one date. How do I put the three pieces of data back into the MonthEntry, DayEntry and YearEntry fields since it is separated on the form like that as a grouped set of controls?

Mike

[dglass]

Store your dates in the DB in SQL format (yyyy-mm-dd), and then break those out by the '-' when you read it back in for display.