I have a workflow where I (a) set a variable to "use date when action is executed", and then (b) do a math operation action on that variable that subtracts 10 and saves it in an integer variable. The result looks something like 3699734390. Why is this? I would like to be able to convert the difference between two numbers like this to a number of hours, but I don't know what they are.
What are these big Date/Time integers?
+5
you got returned number of seconds since 1.1.1900 0:00:00
so you need to convert your value of 10 (you do not specify what should it be - days, hour, minutes...) to seconds and subtract it from date value.
to convert seconds to hours shouldn't be a problem then....
+5Perfect, that is what I needed. Was having a hard time figuring out that it's seconds since January 1, 1900.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.