Vadim Tabakman

Jump to bottom

Nintex Workflow - Current Time with Seconds UDA

There is a common property in Nintex Workflow called Current Time.  This is actually something inherited from SharePoint.  There are also two other item properties to do with time, Created and Modified. All of these properties only give you the hours and minutes for the time, not the number of seconds.  Sometimes, the seconds are needed.  This is where you needed to start thinking outside the box.

Nintex Workflow is an extremely flexible product.  There are a large number of actions that come with it.  Some of these can be used for thing that they aren't intended for.  The best example is the Execute SQL action.

SQL is a powerful language and can do things that aren't specific to database queries.  In the case of getting the current time, including seconds we can run a very simply query.

SELECT CURRENT_TIMESTAMP

This will return you the current date and time, including seconds.  Then you need to parse the data and pull out the seconds.  I've put that into the UDA that can be downloaded at the bottom of this post.

VIDEO

Related Links

Extract data between two text strings

Workflow Constants

Conclusion

What I was hoping to show here briefly, is the ability to do all sorts of things with Nintex Workflow that may not be obvious.  To end this, one other action that is similarly flexible, is the Call Web Service action.  There are so many web services out there, that the number of things you can do is limited only by the imagination.

Downloads

Nintex Workflow 2013

Download the User Defined Action (UDA)  - Download and import the UDA into the Manage User Defined Actions page

Download the User Defined Action (NWF)  - Download and import the UDA into the Create User Defined Action designer page

Posted by Vadim Tabakman Friday, May 30, 2014 7:53:00 AM Categories: Collection Operation Execute SQL Nintex Workflow Nintex Workflow 2013 Regular Expression User Defined Actions
Copyright Vadim Tabakman
Rate this Content 0 Votes

Comments

Friday, September 11, 2015 7:21:14 AM
Don Zimmermann
Gravatar

re: Nintex Workflow - Current Time with Seconds UDA

Hello Vadim,

 

I want to thank you for all your insights into Nintex products.  When searching for a solution I find you are usually the first response I look at and if the answer is not what I am looking for typically it causes me to search alternatives I may not have seen on my own.

Here is another alternative to your approach that does not involve having to get any additional credentials for accessing the SQL Server.  Use the Calculate Date action, include the time, leave all the values at 0, and store the results in the ISO text string.  Then use the substring function to get the seconds from that text variable.

 

Thanks

Z

 

Saturday, September 12, 2015 8:40:05 AM

re: Nintex Workflow - Current Time with Seconds UDA

Hey Don,

That's a great idea.  I like the approach that doesn't require SQL.

Thanks for sharing.

cheers,

Vadim

You must sign in to this site to post comments.
Already Registered?
Sign In
Not Yet Registered?
Register
  • RSS





 

Statistics

  • Entries (235)
  • Comments (1721)

Categories