Date Time problem with Date datatype in SharePoint

Have you noticed that When trying to SharePoint metadata column which use a Date/Time list column, the content in database is stored with 12:00:00AM added along with the date, even if the the column was specified as date only.

Solution: Use another column of type Calculated column of type “Single Line of text” and use the below mentioned formula.

=MONTH([This is My Date Col])&”/”&DAY([This is My Date Col])&”/”&YEAR([This is My Date Col])
Isn’t that easy ?

Advertisement