Hi Albin,

You are correct that Dynamic AI is not seeing the 'DATE' type column as date data. It is a long-standing flaw that I have complained about to Cintac. Grouping and sorting would work just fine on the text date strings but you lose the date-picker and all the built-in date functions.

Your choices are:

1) Change the date types back to DateTime. The fact that you don't use the time portion is irrelevant -- they will all be emtpy values. This would be my choice.

2) Cast the date columns back to DateTime in either dyn-views and/or report formulas

Microsoft introduced this simpler date data type way back in 2008 so it is hard to explain why Cintac never supported. I am told it has something to do with the ADO driver they use.

Regards
Bob