Convert an interval (timestamp) to an integer

[gio]

@FahdERM

Did you create a function for converting an interval (timestamp) to an integer or number?

hello @FahdERM, great question!! this can be done using the TEXTTOINTEGER() function.

as you can see in the demo below, the app is calculating the time from now to a User selected start time. following that, the app converts the Interval to an Integer.

completed app:

trigger to store Interval:

trigger to convert Interval to Integer:

here are the app Variables:

please note that the Integer will be in seconds, and can be manipulated to be in the format you need to pass it into your ERP.

hope this helps, let us know if you have further questions.