This content has been marked as final. Show 3 replies
The generation of the SQL query is based on the regional settings of your FDM Server. The fields are written out based on the defined values for your FDM Service Account.
Is your server running in a Non-US English regional setting where the time delimiter is something different?
Also what SP are you running for your SQL Server? Have you attempted to apply SP3 by Microsoft which also addresses such issues?
Thank you WPaffhausen!
The changing of the regional setting in US English solved the issue ;)
For the posters on this forum, take a look at this post. It gives an idea of ways you can thank those that help you: