locked
in stimulsoft reports, RRS feed

  • Question

  • User77003859 posted

    i hav a text box which is data bound, with a date from SQLServer, now when i preview report, it shows me date and time both,

    from SQLServer i hav taken only date..

    i hav tried to change the textbox edit property to only date, but their exist no date,

    all are datetime

    the query behind is

    Select

    Convert(Date,OverT.AttendDate) as AttendDate,OverT.EmpCode,Emp.Name,Dept.Name As Dept,OverT.OverTH,OverT.OverTM

    from

    OverT inner join Emp on Emp.EmpCode=OverT.EmpCode inner join Dept on Dept.DeptCode=Emp.DeptCode

    where AttendDate between '2011-09-01' And '2011-09-30'

    The textbox is bound to AttendDate

    Monday, October 3, 2011 5:20 AM

All replies

  • User-888860600 posted

    Set the Text Format property of the text component to the required.

    Wednesday, March 13, 2013 7:42 AM