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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources 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

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