Sharepoint 2013: How to change date format of DateTime textbox in NewForm/EditForm?

1k views Asked by At

I have a DateTime Field "Date1" in my list. I need to set its format as "DD-MMM-YYYY" (eg: 29-Mar-2017). I achieved doing this on Display form using the FormatDatetime function in XSL:Select. I need to change it on New/Edit forms too, when date is selected from datepicker

1

There are 1 answers

2
Melad Batta On

As far as I know, this is not possible by using "Calculated Value" property of "Date1" column as self referral is not allowed.

What you can do is create a new "Calculated" column and then use formula =TEXT(Date1,"dd MMM yyyy"). Select "Date and Time" in data type returned and use "Date only" in format.

This will solve your purpose