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


 

7 comments:

Anonymous 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

bubblefootball said...

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

anna 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

gream said...

Online casino games HD is considered as a way to make money in the modern era, the online version is convenient, easy to access because betting on the past a long time may be obvious. Have a hard time and have to travel to play at a real casino. Golden slot Nowadays, the service of this online casino game is well worth the game and there are many privileges available to make the player bet worthwhile and make sure the player is sure. On popular gambling services, gamblers are guaranteed the best bet possible. Simply select the 24-hour betting option at Gclub69 to proceed. It is fast and convenient to get money quickly with the security of the online service that guarantees that. All you have to do is sign up with us via our sixteen fun websites. สล็อตออนไลน์