I am using the Generate Document action. I have date/time fields I want to insert, but I only want it to display the Date, not the Time. In the SharePoint Online list, it is formatted to display Date only. But in the document generated by Nintex Workflow, it displays the date plus 12:00:00 AM as the time.
Is there any way to display only Date? When inserting the tags into Word, it only has format options that include both Date & Time.
Solved! Go to Solution.
Thanks, that sounds like it will work. I will do that. First, I have to work on another issue, and that is developing a way to speed up the process so our employees are not waiting several minutes for while the document is being generated in order for them to sign it.
One step at a time.
I used Build String but it does interpret the function properly.
It appears like this when I send an email to myself to test:
fn-FormatDate(8/13/2019 12:00:00 AM , "MM/dd/yyyy")
Is it fn-FormatDate or FormatDate ? The Nintex documentation suggests fn-FormatDate.
Sorry my mistake. I forgot this is O365 and there are no inline functions in the build string action.
Instead use a Regular Expression action to replace the time with blank.
Expression to use:
Action configuration for your test: