Hi,
I am dealing with a date issue that nobody has been able to solve so far.
I have created two forms in PowerApps, that sends a selected date to an excel file.
Settings in PowerApps:
Default date: Today()
Date time zone: local
Format: dd/mm/yyyy
My browser settings, windows OS region settings and excel region settings are also set local (CET).
My excel column capturing the date has the correct format (also dd/mm/yyyy).
Some examples of the results whenever I am trying to submit a form with a selected date of
Submitting 01/08/2022, excel shows me 08/01/2022.
Submitting 10/08/2022, excel shows me 08/10/2022
Submitting any date with a day after the 12th (any month), will corrupt my form (submit form will show an unknown error).
It seems that the month and the day are being swapped, since excel doesn't accept a number higher than a 12 as the month.
Anyone can help?
