Change Date Format of Site Column
Formatted date in sharepoint list
Formatted date in sharepoint list
First of all create a column with column type, choose Date Only radio button under Date and Time Format provide the column name as ‘Date’
Then Create one more column with Calculated (calculation based on other columns) column type, provide the below said formulas in formula input fields and name the column as ‘Custom Date’
After creating the columns try to enter date from new item form and submit, then you can view the date formatted as shown in Output column below
| Formula (calculation based on other columns) | Output |
| =TEXT(Date,”dd Mmm, yyyy”) | 27 Mar, 2008 |
| =TEXT(Date,”d/m/yyyy”) | 21/7/2008 |
Comments
Comment from G Vijai Kumar
Time September 16, 2008 at 6:28 am
Hi Michael,
Go to, Site Settings > Regional Settings
Set the time zone as per your standards
Comment from Ameet
Time November 20, 2009 at 2:15 pm
I have tried this and it does not work. I cannot create the custom date column it error out saying there are references to other fields.
Comment from G Vijai Kumar
Time November 21, 2009 at 9:55 am
@ Ameet: Did you mean to say that you are unable to create the column with name ‘Custom Date’ if so no problem you can give any name which is available, but make sure that you have to choose the calculated column type and provide formula as mentioned in the post. In formula (=TEXT(Date,”dd Mmm, yyyy”) Date indicates the column name which has to be there in your list
Comment from Brandon
Time April 14, 2010 at 4:38 pm
Tried this and it worked great! Thanks for posting this up, did a google search for help and this was it!
Comment from harithab
Time July 6, 2010 at 5:50 am
This is working.Thank you
Comment from miketech
Time September 15, 2008 at 7:29 pm
Nice post! I created a dataview years ago so START TIME column can be formated to not display the time.
I use:
=TEXT([Start Time],”d/m/yyyy”)
However, there is a problem. If the time is 12:00 PM it reads as previous day.
For example:
It returns 7/20/2008 if the START TIME is 7/21/2008 12:00PM. Do you know how this could be fixed?