fn-FormatDate Function always returning the entire function in string format.


Badge +2

I'm sure I'm doing something ridiculous here.  I am simply trying to format a date.  So for example, I use the following function to format the Created Date:

fn-FormatDate({ItemProperty:Created},"yyyy")

I'm figuring this should return:   2016

What it is returning is:      fn-FormatDate({ItemProperty:Created},"yyyy")

..the entire string of the function I've typed in.

Am I using the correct format?  This is from a string builder.

Thanks for any help!

Cheers,

Troy


5 replies

Badge +3

Go take a look at the following https://community.nintex.com/message/12752

This could be similar to what you are experiencing.

Badge +2

HI All, thanks for the responses.  I had actually read thread 12752 and tried the stringbuilder solution, which did not work.  But I didn't see the solution further down the thread from Ricky.  It worked!

Thanks again,

Troy

Badge

Hi Troy,

Can you please share which method worked for you as I am also facing same issue and its really hard to figure what is wrong with this fn-FormatDate({ItemProperty:23-03-2018},"yyyy-MM-dd") ?/

-Sonam

Badge

Sonam,

Have you found the solution yet? Please let me know.

Sunil

Badge +1

Hi Guys,

Even I am facing the same issue with the string builder. Anybody got a solution for this? Not sure whether fn-FormatDate() still supported in SharePoint Online?

 

 

Reply