kk
Forms Fledgling

Date format does not work in NIntex O365 fn-FormatDate(‍{Variable:TaskDueDate},dddd)

Jump to solution

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.

0 Kudos
Reply
7 Replies
SimonMuntz
Nintex Employee
Nintex Employee

Re: Date format does not work in NIntex O365 fn-FormatDate(‍{Variable:TaskDueDate},dddd)

Jump to solution
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
0 Kudos
Reply
kk
Forms Fledgling

Re: Date format does not work in NIntex O365 fn-FormatDate(‍{Variable:TaskDueDate},dddd)

Jump to solution

its in a workflow. It tried it in both "Set workflow variable " and "Build a string" actions.

0 Kudos
Reply
SimonMuntz
Nintex Employee
Nintex Employee

Re: Date format does not work in NIntex O365 fn-FormatDate(‍{Variable:TaskDueDate},dddd)

Jump to solution
Neither of those two actions support inline functions so that is probably where the issue is.
0 Kudos
Reply
kk
Forms Fledgling

Re: Date format does not work in NIntex O365 fn-FormatDate(‍{Variable:TaskDueDate},dddd)

Jump to solution
Do we know the actions that support inline functions in workflows?
0 Kudos
Reply
SimonMuntz
Nintex Employee
Nintex Employee

Re: Date format does not work in NIntex O365 fn-FormatDate(‍{Variable:TaskDueDate},dddd)

Jump to solution
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.
0 Kudos
Reply
bamaeric
Nintex Employee
Nintex Employee

Re: Date format does not work in NIntex O365 fn-FormatDate(‍{Variable:TaskDueDate},dddd)

Jump to solution

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.

0 Kudos
Reply
kk
Forms Fledgling

Re: Date format does not work in NIntex O365 fn-FormatDate(‍{Variable:TaskDueDate},dddd)

Jump to solution

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.

View solution in original post

0 Kudos
Reply