cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
andrew_x_childr
Nintex Newbie

What are these big Date/Time integers?

Jump to solution

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.

0 Kudos
Reply
3 Replies
mlauer
Nintex Newbie

Re: What are these big Date/Time integers?

Jump to solution
Reply
Automation Master
Automation Master

Re: What are these big Date/Time integers?

Jump to solution

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....

View solution in original post

Reply
andrew_x_childr
Nintex Newbie

Re: What are these big Date/Time integers?

Jump to solution

Perfect, that is what I needed.  Was having a hard time figuring out that it's seconds since January 1, 1900.

Reply