Timestamp: need the right time out of it

[TomBond77]

Hi experts

I have this formula which is not working: For the example in below I would expect 07:00. What is wrong with this formula:

Text(Time(round( (EventDate)), 'hh:mm')) as [Event Time]

Regards, tom

[vincent_ardiet_]

Why have you used a ROUND() in your expression? This is removing the hour, so it makes sense to obtain 00:00.

[TomBond77 · Accepted solution]

solved it: time(frac([EventDate])) as [Event Time],

[vincent_ardiet_]

Sure, but the former one, just removing the round would have fixed the issue.