Please see attachment. I would like to change the format of the date from 27/06/2017 to 27-Jun-2017. I tried the attached but does not work. I also tried fn-FormatDate({CurrentDate}, "dd-MMM-yyyy") with same result.
How do I change the format of date into dd-MMM-yyyy?
+2
use directly formatting string (or a formula that evaluated to formatting string)
eg.
note however, formatting string is applied just in VIEW form.
in NEW and EDIT modes date format follows site settings and you can not change it.
+2Hi Ms. Marian, Thank you very much. I typed in dd-MMM-yyyy and it worked. Appreciate your quick response to my queries.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.