This content has been marked as final. Show 1 reply
The FDM report would not use a date/time of DD.MM.YYYY
It would use a format of DD/MM/YYYY
There is still a conversion or difference due to regional settings that will need to be reviewed
Moreover , the SQL Statement generated for the report , produces the same error when run as Query directly on the Database server.
This is because of the un-matched date time formats between the FDM SQL Statement and the database SQL Login default language.
Regional Settings for DCOM User , showing another Format for Date Representation than the one expected in the Report
As well as , SQL Statement generated produces the same error on the Database server side.
- Logon to the FDM Application Server as the FDM Service Account.
- Start > Settings > Control Panel > Regional and Language Options
- Set the Language Options to "English (United States) and click "Apply"
Let me know if you have any more queries.
Thanks and Regards,