Hi,
On my current app, i have dates on an excel sheet, they are beign shown on a gallery, the problem is the date that shows up is always one day before the actual date( If i type 31/12 on excel, it will show up as 30/12 in the app)(pt-br date format)
Any ideas why this is happening?
Thanks!
This is a workaround and not a perfect solution.
My case: I have a powerapp that reads and writes date into an excel. The data from the excel is used by other services to create charts and to do analysis. Users are in Australia and India. Anytime someone adds a date, the same is saved as Date -1 in excel.
Workaround - When I added a date, it was input as Date 12AM, Considering I am in India, the date was saved as Date-1 1830. So instead of sending date as Date 12AM, I sent it as Date 11AM (considering max(530 hrs for India and 11 hrs for Australia. You can also set one or two hours later just in case). I didnot delete the Hrs and Mins drop down in EDIT screen instead I hid them (set visible to NO) and set the default of 'hours' field to 11. This way when the system writes the date, it does it as Date 12AM (UTC conversion).
Since time was not very important for my data analysis this solution works for me. Hope it helps
Hi @Anonymous
I would have yyyy-mm-dd text in Excel as well. You just patch the Text(Data; "yyyy-mm-dd")
@Meneghino Wait, so it would be like this?
the Data column on excel should be in text format, dd/mm/yyyy
On power apps, < Text(Data; "[$-pt-BR]yyyy/mm/dd"; "pt-BR") > ????
Tried this and Im having the same problem with the ordering part, it orders just by day, not my month or year(Only on equals day numbers, then it goes to order my month
Hi @Anonymous
If the text is "yyyy-mm-dd" then the ordering will work, that is why I normally use this format.
@Meneghino The problem on saving it as a text is that I wont be able to order it as date anymore, I have a button on the list that orders it by date, if its on text format, The days will be in order even if the months are different!
Hi @Anonymous
Can you save the date as text? "yyyy-mm-dd"
This way you can then parse it in your application or in Excel if you need it.
Tried all of your suggestions guys, none of them worked =(
I need to have this because i'm not going to be the one updating the info on the app, so I cant rely on "Just add one date on the sheet"
As for what @AndyPennell asked, i guess its connector, as I'm using a table that's on my OneDrive Business acc, Mayba the timezone of the servers are another one, since its a multinational organization. But there's no possible way to change it only on my side?
Any other sugestions?
On read-reading the OP, is this Excel loaded via static import, or reading an Excel file via a Connector? Excel static import should always treat datetime as the local timezone, but the Connectors version MAY be treating it as the timezone of wherever the servers are located.
I know a bunch about Excel static import, but nothing about how the Connectors work, so the latter is just a guess.
Excel is, um, surprising, when it comes to date/times: they are saved without any timezone data at all.
Also a formula like Text(Data; "[$-pt-BR]dd/mm/yyyy") says "parse the date in Portuguese", but "display it in the local format". If you want Portugues output everywhere, try
Text(Data; "[$-pt-BR]dd/mm/yyyy"; "pt-BR")
Yes, there are two locales here: the input locale (used to parse the date string) and the output locale (used to display the result).
WarrenBelz
791
Most Valuable Professional
MS.Ragavendar
410
Super User 2025 Season 2
mmbr1606
275
Super User 2025 Season 2