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

       

      Datetime.jpg

      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.

       

      Load
      "Ref",
       
      Requisition,
         
      "Region_Web_Details",
         
      "Status_Requisition",
         
      "Start_Date_Requisition",
         
      "End_Date_Requisition",
         
      "Application_Closing_Date_Requisition",
      Date(Floor(ClosingDatePear)) as ClosingDatePear
         
      "Publish_On_Web",
         
      "Intranet_Only"
         
      Resident Vacancies
         
      Where Intranet_Only = 'Yes'
         
      and Status_Requisition = 'Open'
         
      Order by Status_Requisition;

       

      Many thanks in advance for your help