How do I change the format of date into dd-MMM-yyyy?


Badge +2

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.


3 replies

Userlevel 5
Badge +14

use directly formatting string (or a formula that evaluated to formatting string)

eg.

204947_pastedImage_1.png

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.

Badge +2

Hi Ms. Marian, Thank you very much. I typed in dd-MMM-yyyy and it worked. Appreciate your quick response to my queries.

Userlevel 5
Badge +14

great.

if that answered your question please mark 'correct answer'

Reply