how to get time from date

[Anonymous]

Hi ..

i have date like 01/07/2014 07:05:44.0000 i have to display only time of for date..

please help me...

Regards,

chandini.g

[Anonymous]

Hi.. anbu1984..

  Please find following attachment..

In menuduration i have to display only sec..

Please help me..

Regards,

Chandini.G

[#3]

Hi

USE this;

Date#(Timestamp(Datefield,'HH:MM:SS')