0
Answer

Bcs DateTIme FOrmat TO Date Format Conversion

sarath kumar

sarath kumar
11y
1.4k
1

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 !!!

Next Recommended Forum