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?
If you want to use the existing date format, you should write TEXT([Date])
User | Count |
---|---|
43 | |
26 | |
24 | |
14 | |
12 |