2 Replies Latest reply: Aug 27, 2018 9:59 PM by Luis Hinojosa RSS

    how to strip the time from the date.

    Luis Hinojosa

      Hi All,

       

      Can someone please let me know how I can strip the time from the follow-up column. I have tried various options but no luck. File is attached.

      I have tried the following.

      date(floor(timestamp#([Follow-Up Date],'dd/mm/yyyy h:mm'))) as record_date,

      time(frac (timestamp#([Follow-Up Date],'dd/mm/yyyy h:mm'))) as record_time

       

      Very new to qlikview.