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 CAM
Time July 23, 2010 at 12:27 pm
When I try the formula above I am getting an error saying “The formula contains a syntax error or is not supported. “.
Comment from Italo Bertunes
Time October 27, 2010 at 8:01 pm
Hello
I am having one problem with this formula.
When i try to show only Month and Year a recive this message : “The formula contains a syntax error or is not supported.”
For example i have the Colum date only ([Start Date]) and a second colum called [TestCalc] when i tried to to save the following formula i receive the error message that i said earlier. The formula is =TEXT([TestCalc, "mmm-yyyy"])
Comment from ravikumar
Time October 31, 2010 at 7:10 am
i have to change the date format to sharepoint site
that format should be dd-mmm-yyyy when i select the date value from date picker how can i get this value in that column
Trackback from cerita ngentot
Time November 6, 2011 at 7:32 pm
cerita ngentot…
[...]Change Date Format of Site Column[...]…
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?