4 Replies Latest reply: Dec 28, 2012 7:18 AM by Gysbert Wassenaar RSS

    Only load date and not time from date/time field

    Paul Damen

      Hi,

       

      I am trying to load a date from a database into Qlikview. The field I am taking the data from is a date/time field so the data looks like: 28-12-2012 12:07:31

      When I am trying to make a master calender it keeps runing because of the time field and therefor making a endless amount of fields.

       

      I have tried to load the data with a left function, date function, in a variable but none seems to be working.

       

      Hope someone can help me with only loading the date and forgetting the whole time field.

       

      Regards,

      Paul