appuals.com

How to Fix ‘Conversion failed when converting date and time’ in SQL Server

When working with dates and times in SQL Server, it’s common for formatting discrepancies to cause issues during query execution. To prevent errors, it’s crucial ...
GitHub

Conversion failed when converting date and/or time from character string.

('SELECT DISTINCT CONVERT(datetime2, CONVERT(varchar(4), ' "[MonthlyUserSummary].[Month]) + '/01/01') AS [datetimefield] FROM " '[MonthlyUserSummary] WHERE ...
Microsoft

Working with date/time values and SQL Server

TL;DR: if you want to use date/time values from a SQL Server table in PowerApps, use the datetimeoffset column type and your life will be easier. The datetime (and friends) column type represent an ...