I have in several apps a function to return t...

I have in several apps a function to return the initials of the user (taken from the email, using the LEFT(USEREMAIL();FIND("@";USEREMAIL()-1)) -function) AND a timestamp using the NOW() -funtion, put together with the CONTACENATE() -funtion.

However, the output value for the NOW-function is in the american date-format (MM/DD/YYYY HH:MM:SS), and I would perfer this format: (DD/MM/YYYY HH:MM:SS)

Any Ideas?

0 1 261
1 REPLY 1

If you want to use the existing date format, you should write TEXT([Date])

Top Labels in this Space