Tuesday, November 12, 2013

Calculated field date format

According to the regional settings of your system , the format of the date will follow these settings in any list , however if you have a date field in any list and you want to format it you can follow this solution

Problem : Formatting date field in list.

Solution : you can play with that by creating calculated field that contains the following formula
 =TEXT([Date Field Name],"dd mm, yyyy")

But if the date field is optional so the NULL values will return default date value so you need to check if the value is NULL to return nothing , the formula will be
=IF([Date Field Name]=""," ",TEXT([Date Field Name],"dd/mm/yyyy"))

The first part checks if the value is NULL so it returns “ “ however you can add any text in between if you want like “ No date “ , the second part is placing the date text and format it and you can play with the format types.

Calculated field date format
Calculated field date format



eventplanner5 said...

Nice post. Very informative.

Anonymous said...

I'd like to find out more? I'd care to find out
some additional information.

Feel free to surf to my webpage :: phoenix personal injury attorney

web lol said...

kul pejg

General Manager said...

It's great work done on content management,.
Decoupled CMS

Анна Фрейт said...

There are thousands of sites on the internet and all in all definitely provide information on the results of each article, but the article on this site different from the others. The article was very detailed and easily understandable http://awriter.org/freshessayscom

james said...

I have bookmarked your website because this site contains valuable information in it. I am really happy with articles quality and presentation. casio