All dates and timestamps in QlikView and Excel are just numbers.
What you see is just a mask that format numbers into days, hours, etc.
1 unit = 1 day, 1 hour = 1 /24 , 1 second = 1 / 24/3600 and so on.
to apply the timestamp mask back again, use this:
you can replace the field by anything else (e.g. an expression) to work with charts.
You can check the article about timestamp on the help to get more details.
Thank you so much Hector! I'd kiss you if I could.
I have been pulling my hair out over this. I was using the time() function...but you pointed one thing out to me the
importance of the separator being '.' and not ','. In my file it is ...guess what...yup... ',' . I just used Replace()....and it worked.
Time(Replace(Field, ',', '.'), 'hh:mm:ss')