SOLVED - How to deconstruct a date?
Posted: Wed Jul 27, 2011 2:48 am
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
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