The reason for this thread arose from the fact that Dynamic recognises "date" types as string.

We were doing a proof of concept of using Dynamic as a BI tool for a client. They are not happy of the fact that "dates" are not "dates" in Dynamic and they are at the present evaluating other tools like Power BI and the proof of concept has stoped. Also I can't assert if this will be fixed in Version 7 or when it will be available.

For the time being we won't spend more time in this issue.

I would like to thank everyone for their solutions and suggestions.