Community Tip - You can subscribe to a forum, label or individual post and receive email notifications when someone posts a new topic or reply. Learn more! X
Hi all,
I have a requirement where there are 2 fields of an infotable say data1 (basetype infotable) and data2(basetype infotable).
Now I need to create an infotable which is as such data1-data2
That is the elements of data2 must be subtracted from data1 and the result must be in answer.
How to achieve it?
Solved! Go to Solution.
You should do something like this:
var result = Resources["InfoTableFunctions"].DeriveFields({
t: myInfotable,
types: "LONG",
columns: "differenceInMilliseconds",
expressions: "dateDifference(data1,data2);"
});
Hi, keep in mind that datetime is calculated in milliseconds, so you can use that for your math logic and then output the result in the datetime format again.
You should do something like this:
var result = Resources["InfoTableFunctions"].DeriveFields({
t: myInfotable,
types: "LONG",
columns: "differenceInMilliseconds",
expressions: "dateDifference(data1,data2);"
});
Thanks a ton! It worked