sarath kumar

sarath kumar

  • NA
  • 163
  • 9.7k

Bcs DateTIme FOrmat TO Date Format Conversion

Jun 21 2013 8:31 AM

Version: sharepoint Online 365 I am having Date Field in DB . While i am retrieving in BCS Its showing as Datetime Format.

 How can trim Time Value. I need to display in Date Format only .

While i open my form In Sharepoint Designer :

<Query>
  <OrderBy>
    <FieldRef Name="ID"/>
  </OrderBy>
</Query>

    <ViewFields>
         <FieldRef Name="JobNumber"/>
         <FieldRef Name="JobName"/>
         <FieldRef Name="JobDescription"/>
         <FieldRef Name="StartDate"/>
         <FieldRef Name="EndDate"/>
         <FieldRef Name="JobStatus"/>
         <FieldRef Name="Comments"/>
    </ViewFields>

Please provide any camel changes or Some tips !!!