Date format does not work in NIntex O365 fn-FormatDate({Variable:TaskDueDate},dddd)..Outputs the entire string back. This has been raise quite a few times in the community but have not seen a solution yet. I also tried fn-FormatDate({TextStart}{Variable:TaskDueDate}{TextEnd},dddd). this gives empty string.
Page 1 / 1
Hi,
Where are you using this formula?
What action or form control?
I tested in a calculated value control on a form and it works as ecpected.
formatDate(Current Date,"dddd") Output Monday
Where are you using this formula?
What action or form control?
I tested in a calculated value control on a form and it works as ecpected.
formatDate(Current Date,"dddd") Output Monday
its in a workflow. It tried it in both "Set workflow variable " and "Build a string" actions.
Check this post to see if it might be helpful: How to get the day of week in Nintex Workflow
Using that post, you can create a list column of type Calculated and use that to get the day of the week number. You could use a Switch workflow action to evaluate the number in the calculated list column and have one branch for each day of the week number (seven total). Create a text workflow variable and have a Set Workflow Variable action store the day of the week name in the variable for each of the seven branches. So, branch 1 would store Sunday in the variable, branch 2 stores Monday, etc. You could then use the day of the week name in your workflow accordingly.
Might not be the most elegant solution, but it does work.
Neither of those two actions support inline functions so that is probably where the issue is.
Do we know the actions that support inline functions in workflows?
Nintex for O365 does not have inline functions. That is why you never see a menu containing inline functions to choose from as you do with Nintex On-premise.
So i did the traditional way used a SP list calulated field to get the weekday and use it in my component workflow. Once the workflow gets the value it deletes the entry from the temp list.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.