GMT+02:00 cannot be converted to the correct Windows time zone name

0
Hello everyone, I’m using DATEDIFF function to compute the diff between 2 dates. It’s running perfectly with my local MySQL DB. Once deployed to remote MS SQL Server, we got the following error: GMT+02:00 cannot be converted to the correct Windows time zone name   Thanks in advance for your support.  
asked
1 answers
1

This sounds like a SQL implementation issue between two different types of database.

If you want to find the number of days between two dates in a Mendix application you can use the built-in daysBetween function. 

https://docs.mendix.com/refguide/between-date-function-calls/#6-daysbetween

I hope this helps.

answered