I'm having massive issues with numbers/text/dates!
Is it possible that anyone can clear this? The issue is manifold...dates get messed up totally...e.g. a record from 03.072020 (July, 3rd, fkn 2020) shows up as 07.03.2021 or even 2022. Thereby the year is only a secondary problem, the main problem is that months and days get mixed up. Very strange. And then the year get a value of...in the future..quite unreasonable
Have you tried formatting the information in the field.
Also is the date correct in the source location?
Yes, I've tried like so (for German Date Format), trying to compensate for the time difference (which is not working with that formula)):
), "[$-de-DE]dd.mm.yyyy hh:mm")
It's all in the "cloud" now, so I've got no idea about the time zone on whatever server. And it should not matter, I need a foolproof solution regarding time.
Last time i checked in the connected Excel file, typing a formula like Now(),..it said 7 hours behind, like New York maybe
Now, coworkers trying to use my app, send me recrords of 2022, 03.07 or 07.03 for example, that should be 2020, July, 3rd instead, very confusing
Hi @TJO ,
Try this to a label text property, that will give you the clue of the timezone of your tenant:
Then you can work the other formula as same:
Text(DateAdd(DateTimeValue(Text(ThisItem.Datum,"[$-de-DE]dd.mm.yyyy hh:mm")),TimeZoneOffset(),Minutes),"[$-de-DE]dd.mm.yyyy hh:mm")
I hope this resolved your issue if you see any challenge/need further help please let me know I am always happy to do it for my community.
If this post helps you give a 👍 and if it solved your issue consider Accept it as the solution to help the other members find it more.
@KrishnaV : Thank you. The formula below returns 05.07.2020 22:00 and it's 06.07.15:20 now.
When I go to the connected Excel file with the records and type =Now() in any cell the return is 7/6/2020 6:20. So I'm still confused
Find your favorite faces from the community presenting at the Power Platform Community Conference!
See the latest Power Apps innovations, updates, and demos from the Microsoft Business Applications Launch Event.
ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.
Features releasing from October 2020 through March 2021