Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Tell us which business and trade publications you read most regularly: RESPOND NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
mloy3
Contributor II
Contributor II

Removing not hiding Date from Timestamp

Hi, I am trying to do some interval summation with 2 different timestamp. However, i am not able to remove the date that is associated with Expression A(only interested in hh:mm). 

Expression A:
Using a simple formula to add the time stamps together:
time([Work Unit Complete Hour] & ':' & [Work Unit Complete Minute], 'hh:mm')

however, when i check further using:
date(time([Work Unit Complete Hour] & ':' & [Work Unit Complete Minute ], 'hh:mm'),'m/d/yyyy') 
i noticed a bunch of dates associated resulting in correct hh:mm but wrong dd/mm/yyyy when i sum this with another field.

I am not trying to hide the display, but really removing the date associated so that i can add this to another expression. 

Labels (2)
1 Solution

Accepted Solutions
sunny_talwar

I am guessing you are must be seeing a date from the year 12/30/1899? It is just a Date for when the value is 0

image.png

View solution in original post

2 Replies
sunny_talwar

I am guessing you are must be seeing a date from the year 12/30/1899? It is just a Date for when the value is 0

image.png

mloy3
Contributor II
Contributor II
Author

Thank you Sunny, another colleague pointed out to me that i was using 'm/d/yyyy' instead of 'M/D/YYYY' and that made the whole difference when doing the summation. But yes, i thought what you pointed was an error with the data which i couldnt verify