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

Date format outputs seconds as 00

Jump to solution

I'm using Nintex Workflow to output the current time to the Title field. I'm using the inline function FormatDate to produce a time string of hours, minutes and seconds as below:

fn-FormatDate(Current Time,HHmmss)

However the seconds are always output as 00 e.g.: 175200

Am I missing something?

Labels: (2)
0 Kudos
Reply
6 Replies
achilles_aditya
Nintex Newbie

Re: Date format outputs seconds as 00

Jump to solution

Hi,

Please check the post at

https://community.nintex.com/community/build-your-own/blog/2015/08/11/date-and-time-format-strings-q....

Try if "T" is giving you the result in seconds

Reply
ms
Nintex Newbie

Re: Date format outputs seconds as 00

Jump to solution

Hi,

Thanks. Yes using "T" produces the same result: 14:19:00

0 Kudos
Reply
achilles_aditya
Nintex Newbie

Re: Date format outputs seconds as 00

Jump to solution

can u try javascript to check the time date related settings are proper? check the link https://community.nintex.com/thread/4800 

Reply
emha
Nintex Newbie

Re: Date format outputs seconds as 00

Jump to solution

I agree with Aditya, that it would be easier to get datetime value with seconds precision in forms with some javavascript.

if you insist of doing that in workflow then only possible way I'm aware of is getting current time in ISO format. that's only datetime format in worklow with seconds precision.

you can do it like that

you will get an output like: 2016-10-19T10:32:18Z

you will need then to parse it for respective time parts with eg. regular expression

Reply
ms
Nintex Newbie

Re: Date format outputs seconds as 00

Jump to solution

Thank you Marian! The Calculate Date action produces the seconds: 2016-10-19T10:52:53Z

EDIT: For additional information:

  • Configure the Calculate Date to output the ISO time to a text variable (varTXTDate):

  • In the next action I use an inline function to format the text variable:

fn-FormatDate(varTXTDate,yyyyMMddHHmmss)

0 Kudos
Reply
ms
Nintex Newbie

Re: Date format outputs seconds as 00

Jump to solution

Thanks for your assistance Aditya! Marian's solution worked for me.

0 Kudos
Reply