Hello everyone,

For those of you who need the time difference in terms of minutes, here's Miruna's code I have adapted:

            Dim duration as Integer
            Dim dateA as DateTime = GetTokenValue("token name:left argument")
            Dim dateB as DateTime = GetTokenValue("token name:right argument")
            duration = (dateA - dateB).Days * 3600 + (dateA - dateB).Hours * 60 + (dateA - dateB).Minutes
            SetTokenValue("output token name",duration)

Alternatively, you can use the Script activity and do the calculation directly with code:

int days = (DateTimeA - DateTimeB).Days

Using the "Assign Token Values" activity, you can separate out the different values the dates and then do individual calculations. You will need to do some logic there for if the years are different but you should be well on your way to getting this information once you have these values.

Hey Ken,

thanks for the quick response.

I'm still struggling a bit with this concept. Should I assign both dates to a multi value token and do the calculation?

thanks in advance.

Tony

I'll give it a spin... let you know how it goes, thanks!!

Tony

Thanks for the feedback.

I'm rather new to vb.NET, can I please see a snippet of the code as to what it should look like? I will copy in an example of what I currently have - I do believe I'm missing some information. I believe that it has something to do with the assigning of the generated value to a token.

FYI -

Public Class Script1

Inherits ScriptClass90

'''<summary>

'''This method is run when the activity is performed.

'''</summary>

Protected Overrides Sub Execute()

'int days = ("RETRIEVEFIELDVALUES_DATE1" - "RETRIEVEFIELDVALUES_DATE2").Days.

End Sub

End Class

End Namespac

100% perfect. worked like a charm.

Thank you.

Tony

Hi Mirunda:

Thank you for this, much appreciated.

Tony

Late post to this thread.  For those that do not want to use the script activity I do have a custom workflow activity that will accept two datetime values, determine their difference, and provide tokens for number of milliseconds, seconds, minutes, hours, days, business days, weeks, calendar weeks, months, and/or years between them.  It is a free custom workflow activity, available at www.qfiche.com  on the Products page

hello Cliff

provided link not working 

Thank You.

If anyone is still looking for another version of this with C# you can use this and it will give you the HH:mm:ss:ms format.