6 Replies Latest reply: Oct 26, 2017 6:52 AM by Anand Chouhan RSS

    Date part missing.

    qlik tech

      Hi

       

      I have a field taken from a spreadsheet that has a timestamp however for few records it just has the time. How do I populate the missing date? WHen I calculate the interval I get the wrong figures as its subtracting  time (epoch date I assume)  from the timestamp.

      eg: 11:30:00  - 23/10/2017 11:10:10

       

      Your help is appreciated.