News

('SELECT DISTINCT CONVERT(datetime2, CONVERT(varchar(4), ' "[MonthlyUserSummary].[Month]) + '/01/01') AS [datetimefield] FROM " '[MonthlyUserSummary] WHERE ...
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 ...