Query changing dates to numbers and pulling data incorrectly

[Ronderbecke]

Currently I am trying to figure out why Query is changing the information and pulling on cells it shouldn't be? I have a table setup which is this:

<style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style>[TABLE="width: 0"]
<colgroup><col style="width: 100px"><col width="100"><col width="100"><col width="100"><col width="100"><col width="100"><col width="100"><col width="100"><col width="100"><col width="177"></colgroup><tbody>[TR]
[TD]Day[/TD]
[TD]Date[/TD]
[TD]8:00 AM[/TD]
[TD]10:00 AM[/TD]
[TD]12:00 PM[/TD]
[TD]2:00 PM[/TD]
[TD]4:00 PM[/TD]
[TD]6:00 PM[/TD]
[TD]8:00 PM[/TD]
[TD="align: center"]Availability[/TD]
[/TR]
[TR]
[TD]Saturday[/TD]
[TD="align: right"]8/31/2019[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: center"]43711 10:00 AM[/TD]
[/TR]
[TR]
[TD]Sunday[/TD]
[TD="align: right"]9/1/2019[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: center"]43708 43709 43710 [/TD]
[/TR]
[TR]
[TD]Monday[/TD]
[TD="align: right"]9/2/2019[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD]Tuesday[/TD]
[TD="align: right"]9/3/2019[/TD]
[TD][/TD]
[TD]10:00 AM[/TD]
[TD][/TD]
[TD="align: right"]2:00 PM[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD]Wednesday[/TD]
[TD="align: right"]9/4/2019[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD]Thursday[/TD]
[TD="align: right"]9/5/2019[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD]Friday[/TD]
[TD="align: right"]9/6/2019[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD]Saturday[/TD]
[TD="align: right"]9/7/2019[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]2:00 PM[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD]Sunday[/TD]
[TD="align: right"]9/8/2019[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD]Monday[/TD]
[TD="align: right"]9/9/2019[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD]Tuesday[/TD]
[TD="align: right"]9/10/2019[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD]Wednesday[/TD]
[TD="align: right"]9/11/2019[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD]Thursday[/TD]
[TD="align: right"]9/12/2019[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD]Friday[/TD]
[TD="align: right"]9/13/2019[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD]Saturday[/TD]
[TD="align: right"]9/14/2019[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD]Sunday[/TD]
[TD="align: right"]9/15/2019[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD]Monday[/TD]
[TD="align: right"]9/16/2019[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD]Tuesday[/TD]
[TD="align: right"]9/17/2019[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD]Wednesday[/TD]
[TD="align: right"]9/18/2019[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD]Thursday[/TD]
[TD="align: right"]9/19/2019[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD]Friday[/TD]
[TD="align: right"]9/20/2019[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]43711 10:00 AM[/TD]
[TD][/TD]
[TD]43708 43709 43710 [/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: center"][/TD]
[/TR]
</tbody>[/TABLE]

The query function should be pulling on cells with numbers in both the date field and time field. When there is spacing between them; however, it pulls random dates for some reason? Also its converting all the dates to number format and I can't seem to stop it from doing that? Here is my current formula:

=IFERROR(QUERY({ArrayFormula({C2:C22}&" "&{G2:G22}),G2:G22},"Select Col1 Where Col2<>''"),"")

In this instance, Date is column C on the sheet. Did I mess something up with this formula?

 

[Joe4]

I have never use Query in Excel before, so really cannot help there. But I can help you with some understanding how Excel functions:

Also its converting all the dates to number format and I can't seem to stop it from doing that?

Excel actually stores all dates and times as numbers, specifically the number of days since 1/0/1900. The number just has a Format to display it as a date.
This can easily be seen by entering any date into any cell in Excel. Then change the format to General, and you will see the date as Excel does.
Note that changing the format does NOT actually change the value - they are the same. It just changes how it is displayed.

Time is just the fractional component of one day.
So 6:00 AM is equivalent to 0.25.
12:00 PM is equivalent to 0.5