I am trying to solve an issue regarding a timing difference between On Premise Gateway connection and my App.
My app triggers an stored procedure and i want to display the execution information(time of execution and result) in the app.
The app sends an email to the users when it finishes and displays the same information in the app. But there is a timing difference between the displayed time in the email and the app. It is always 2 hours and i believe that it is a timezone issue perhaps but i am struggeling how to change this date in the datatable in my app.
Does anyone have an idea to fix this?
thank you in advance
You will want to look at the TimeZoneOffset function.
Your database will be storing the date as a UTC date, so you will want to convert to and from UTC at all times to get accurate times.
Take a look at the above mentioned document and you will see toward the end of it the formulas for converting to and from UTC.
I hope this is helpful for you.
HI @RandyHayes ,
Before i posted this message i already looked into this formula but i can't get it to work in a Datatable. In this datatable i display the latest run of a SQL Job.
I did some test put in the query within a label then it works but can't get it to work in a datatable.
Do you have any idea's?
So the issue is with the datatable control. It is very inflexible as to any formatting or data manipulation. Therefore, what you need to do is "pre-shape" your data for the datatable.
The easist way to do this is with the AddColumn function.
In this case, you can alter your formula for the Items property similar to this:
AddColumns(yourOriginalItemsProperty, "myConvertedDate", theDateConversionFunction)
Substitute your current Items property formula in the "yourOriginalItemsProperty".
Name the "myConvertedDate" whatever you want (except an already existing column name).
Put the formula you need to convert your date into "theDateConversionFunction".
Then...add the "myConvertedDate" column (or whatever you call it) to your DataTable fields list.
This will give you the formatted and converted value in your table.
Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.
Fill out a quick form to claim your user group badge now!
Attend for two days of expert-led learning and innovation on topics like AI and Analytics, powered by Dynamic Communities
Features releasing from October 2019 through March 2020
Join us for the Microsoft Business Applications Virtual Launch Event on Thursday, April 2, 2020, at 8:00 AM PST.
Innovate, Collaborate, Grow - The top training and networking event across the globe for Microsoft Business Applications