COUNTIFS on dates returned from MYSQL Query

[NickGB]

I'm struggling to get COUNTIFS to work when the dates I am tying to count are returned from a MYSQL table.

The formula I have used is:

=COUNTIFS(Smart!$Q$2:$Q$316,">"&(D12),Smart!$Q$2:$Q$316,"<"&(E12))

The actual dates are within the MYSQL table

=Table_Query_from_Primus[[#Headers],[Report_Forecast_Pre_nomina_Pre_nomina_date86]]

If I do a simple =Smart!$Q$2 if returns the date fine however as soon as I try and work in the COUNTIFS function it does not count.

I'm sure this is me not thinking this through properly but any help would be greatfull as I'm trying to create a dashboard.

 

[NickGB]

Yeah they were coming in correctly ddmmyyyy. Really odd. Was looking everywhere for a resolution and even mrexcel consulting fee based support (although Mr E didn't reply... ).

it must be something to do with how msquery returns the dates/data I guess.
Cheers nick