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.
Answer
Date format does not work in NIntex O365 fn-FormatDate({Variable:TaskDueDate},dddd)
Best answer by kk
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.
+23- Nintex Employee
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
+14Check 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.
+23- Nintex Employee
Neither of those two actions support inline functions so that is probably where the issue is.
+23- Nintex Employee
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.