Hello,
I having some issue with this Unix Timestamp. Previously before update, my calculation for this unix timestamp work perfectly. I able get the total hour by formula ((Time End - Time Start) / 3600000). Now seem the formula not working. I do try re-configure and check, at database can show the timestamp in unix format. But still having issue to get the result.
Kindly advise.
Thanks.
Hello,
Update. I do change the Unix Timestamp to Datetime format and check back the insert data on database. Seem the UTC having issue…I do update the UTC for the docker to my current UTC time…This parts was fixed and I able do the calculation for this. All calculate correct as what I want and on database I able see all the figure is correct. But on UI, it will show the correct value once and change to wrong value in sec/page refresh. (as below picture show in 1 sec the value change) and last picture show value inside the database.
Kindly advise how to fix this issue.
Thanks.
Hello,
Anyone can assist?
Im still stuck here with this refersh issue and record not rander properly on UI.
Thanks.
We are working on this issue.
There are some differences between frontend and backend formula calculation.
Date type.string type (which can not be calculate in subtraction).So, a better solution to define the formula, you could use some other function to transform the date variables to Date (or number) type first, then subtraction could be used.
For example:
(DATEVALUE(yourDate1)-DATEVALUE(yourDate2))/3600000
Hello,
Thank you for your suggestion. Work perfectly. I just amend the formula as your suggestion.
Perfect. Appreciate your assist. 
It has been many days stuck with this issue…as before update version, everything perfect.
Thank you so much.
