DAX - Split date from time to only show time

[Antonio Pantalones]

PowerePivot
ACCESS MDB Data Connection.
Import Data format: (hard coded 12/30/1899, can't change this at source)
12/30/1899 12:03:00 AM
12/30/1899 12:07:00 AM
12/30/1899 12:11:00 AM
etc.
Thinking simple doesn't work: =(US_CURVE_DATA_CURRENT[TI<WBR>ME]-12/30/<WBR>1899)

Thanks

<TABLE class=h><TBODY><TR><TD class=l></TD><TD></TD><TD class=r></TD></TR></TBODY></TABLE>

 

[VoG]

Try

=MOD(C2,1)

and format as Time.

 

[Norie]

Are you sure there's actually a date there?

What happens when you format as Time?

 

[Antonio Pantalones]

Found the answer

=FORMAT(US_CURVE_DATA_CURR<WBR>ENT[TIME],<WBR> "hh:mm:ss")

 

[Norie]

That suggests it is just a time.

 

[VoG]

That will change the displayed value but will not change the underlying value.

 

[Antonio Pantalones]

Great points, but I think this works ok for now.

 

[Norie]

That's the important thing.

Just be careful if you need to use it in calculations.

PS You are doing this on a worksheet?
I thought Format was for VBA and TEXT was the worksheet equivalent.

 

[Antonio Pantalones]

This is for a simple PowerPoivot dog and pony, nothing fancy. Sometimes hard coded data is really challenging.. Thanks for your help.