cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
KarlNixon
Helper III
Helper III

BUG? SQL Date field record

This is really weird!

I have an SQL date table

 

KarlNixon_0-1634712846353.png

With the following data types

 

KarlNixon_1-1634712893764.png

 

But when I bring the table into PowerApps via the SQL connector.

 

I get a duplicate record 2/10/21 BUT NO 3/10/21 for the Date field but correct records for the DateInt field????

 

KarlNixon_3-1634713608083.png

No other date is wrong in the entire table (429 records).

 

I even deleted the record and reentered but with the same outcome - PowerApps doesn't like 3rd October 2021!

 

Any ideas?

 

 

Karl 

2 REPLIES 2
KarlNixon
Helper III
Helper III

No such problem with the PowerBI connector to the same table

 

KarlNixon_0-1634773158915.png

 

timl
Super User
Super User

Hi @KarlNixon 

This is a really strange problem. It's really unexpected behaviour so I'd recommend that you raise a support ticket by clicking the 'Create support ticket' button on the following page.
https://powerapps.microsoft.com/en-us/support/  

I tried to recreate the problem but wasn't able to do so. My app displayed the date value 3rd Oct correctly. I can't imagine why your app doesn't like 3rd Oct - it's so strange!

Helpful resources

Announcements
October Events

Mark Your Calendars

So many events that are happening this month - don't miss out!

Ignite 2022

WHAT’S NEXT AT MICROSOFT IGNITE 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Power Apps Africa Challenge 2022

Power Apps Africa Challenge

Your chance to join an engaging competition of Power Platform enthusiasts.

Users online (3,435)