A custom source API call returns a date field in microseconds format.
Does NQE have a built in function to convert?
For example, 1725899407, to Sept. 9, 2024. Currently I don’t need the hours and minutes but in the future it may be necessary.
I’ve searched “date” and “microseconds” in the documentation and online without success.
Best answer by Tyson Henrie
+2We don’t currently have a built-in function for Unix Epoc time. We added a “uptime” to the data model. In that case it is “relative” time. We then have a function to turn the “relative seconds” to Years, Days, Hours, Minutes.
Let me see what that would look like as a user function.
-Tyson
Oddly extractJson seemed to treat it as a Float. It didn’t like it as type Number so I changed to Float and it passed but not with correct result. lastUpdateMicros: Float vs. lastUpdateMicros: Number worked.
+2
Hello
fwd.app was upgraded to 24.9 late on Wednesday. Now you can write
[{
Date: date("1970-01-01") + seconds(1725899407),
Timestamp: timestamp("1970-01-01T00:00:00Z") + seconds(1725899407),
}]which gives
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
