7 Replies Latest reply: Apr 21, 2015 7:46 AM by Tim Saddler RSS

    Datetime in Resident Table won't convert to Date

    Tim Saddler

      Hello all

      Silly issue this but i have extracted data from sql server into qlikview



      I re-extract this from the resident table but the floor function doesn't work.

      I need to show just the date - without the time.


      Date(Floor(ClosingDatePear)) as ClosingDatePear
      Resident Vacancies
      Where Intranet_Only = 'Yes'
      and Status_Requisition = 'Open'
      Order by Status_Requisition;


      Many thanks in advance for your help