Saturday, October 17, 2015

How to calculated column in SharePoint Date field?

=TEXT([Date],"mm")   =>       date is 1-Jun-2015

Result:
06
=TEXT([Date],"mmmm")  =>    date is 1-Jun-2015
Result:
January

=TEXT([Date],"mmm")   =>    date is 1-Jun-2015

Result:
Jan

=TEXT([Date],"yyyy")   =>    date is 1-Jun-2015

Result:

2015


=TEXT([Date],"dd")   =>    date is 1-Jun-2015

Result:

01

No comments:

Post a Comment