Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
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 (1)
1 Solution

Accepted Solutions
sunny_talwar
MVP
MVP

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
MVP
MVP

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