Forum Discussion
Error in Comparing Date/Time Columns
Yes, your 'InTime' column is currently time format -> 10:01:01
When you use the TIME() function you will return datetime format -> 1899-01-01 10:01:01If you create a new column, converting the values that you have in your 'InTime' column using TIME() you should get the same timestamps but in datetime and with 1899-01-01 as the Y/M/D
Use that column instead of the 'InTime' column and the original expression should work.
Oh! So is there a work around for my requirement?
tex628 wrote:I know it looks weird but TIME() converts to datetime -> 1899-01-01 12:01:01.
Try and use it as a measure in a card and watch what it produces!
Community ChampionYes, your 'InTime' column is currently time format -> 10:01:01
When you use the TIME() function you will return datetime format -> 1899-01-01 10:01:01
If you create a new column, converting the values that you have in your 'InTime' column using TIME() you should get the same timestamps but in datetime and with 1899-01-01 as the Y/M/D
Use that column instead of the 'InTime' column and the original expression should work.
Works! Thank you so much