HI

Hi, I have created the following datetime table DateTime = ADDCOLUMNS ( CROSSJOIN ( CALENDAR ( DATE ( 2014, 1, 1 ), DATE ( 2025, 12, 31 ) ), UNION ( ROW ( "Time", TIME ( 1, 0, 0 ) ), ...

Need Help

abc_777
4 years ago
my invoiceDT column got 12:00:00 hr with the date.
even I have separate column with TIME with data type also TIme and has time value in it. and i made relationship with it but no luck. so what i should to to resolve

thx
abc_777
4 years ago
please some one help me out. where the issue i am having to resolved this. or can do remote to my my machine and see the issue.

amitchandak

Super User

4 years ago

abc_777 , invoiceDT should also be at the hour level

invoiceDTHout = datevalue([invoiceDT]) + time(hour([invoiceDT]), 0,0)

abc_777

Solution Specialist

4 years ago

my invoiceDT column got 12:00:00 hr with the date.

even I have separate column with TIME with data type also TIme and has time value in it. and i made relationship with it but no luck. so what i should to to resolve

thx

abc_777
Solution Specialist
4 years ago
please some one help me out. where the issue i am having to resolved this. or can do remote to my my machine and see the issue.

Forum Discussion

HI