Format is Date in Source Data but Text in query?

[jset818]

Edit: I was able to fix the issue by reentering the dates in the Website Created column.

I'm trying to find the number of days between two dates, the Start Date and Website Created date. They're both formatted as Date in Excel but Access sees Website Created as Text even though it's clearly Date.



I'm using a simple [field]-[field] formula but Access keeps giving me the Datatype is Mismatch error. I even copied and pasted the rows a few times so at least 10 dates are at the top of the column. Why doesn't Access recognize it as Date? In the Source Data, almost all the cells in Start Date has a date and most of the cells in Website Created are blank.

Expr1: [MAX Mega].[Program Start Date]-[MAX Mega].[Website Created]

[June7]

Already marked as solved - is it? Want to share solution?

[jset818]

Already marked as solved - is it? Want to share solution?

I edited my original post with the solution. Although I'm not sure why or how it fixes it but all I did was reenter the dates in the Website Created column.