What is one way to take have day of the month, month, and year in separate columns and combine it to create a date field?

	A.	In order to combine the columns to form a date, simply create a formula that in layman's terms looks like month&"/"&day&"/"&year and no need to worry about the data type of the columns.
	B.	In order to combine the day of the month, month, and year fields into a date field, first make sure that all these fields are text values, then create a new column that says [month]&"/"&[day of month]&"/"&[year], and then make sure this new field is a dat
	C.	To combine the columns, use a left join to first join the month and day, and then another left join to join this month and day combination with the year.
	D.	It is not possible to combine several columns into a date if it has not already been done.