Need help in table creation for dropdown list

Question

Hi all, I have table with name Dates. Fields are: Date of Joining Previous Date of Visit Number of Visit Reffered Department

For Date of Joining and Previous Date of visit fields entering the data from drop down list. like...Select Day....Select Month.....Select Year. Then how many fields should be created.....How can i design this entire table????? pls help.

Thanks, Sumit

Answer 1

Design the table with DateTime values for those fields

DateOfJoining : datetime

PreviousDateOfVisit : datetime

Then its up to your UI to combine the selections of the split drop down fields back to one datetime parameter for inserting / updating, and vice versa for displaying.

This makes it far easier to query against these values.