Hi,
I have a Power Apps application that is working perfectly. Someone enters dtaa in a Form and it needs to be shown on a screen or on an editpage. The only exception is working with datevalues. I have been working on this for the past couple of days, but it doesn't seem to work. I have a few examples;
1) When I enter the date in the datepicker, I enter it as dd-mm-yyyy, but sometimes (mostly when the d < 12), it automatically stores the date in Excel as mm-dd-yyyy.
2) When I enter datevalues into Excel, it automatically changes the way it stores the datevalue, as seen on the picture. .
3 different kinds of storages of datevaluesAll datevalues were entered with the same datepicker, but it changes the way it stores the data in Excel.
3) When everything is set, it sometimes changes the datevalue to a date + time. The consequence is that the rest of the App is not able to read the data anymore.
I have many more examples, but my question is: Is this a common thing? And is it because of Excel; Is a specific setting required in Excel of Power Apps? I have tried everything, from changing the language of datevalues storage in Excel, Power Apps or both, changing the columntype to text, date or standard. Or do I need to change my datastorage to Sharepoint for example?
I just can't get it to work reliably and consistent in Excel, it seems.
Thanks in advance,
Max
