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

[alexandros17]

Use the function Time() so:

Time( 01/07/2014 07:05:44.0000) returns 07:05:44

[maxgro]

= time(frac(date#('01/07/2014 07:05:44.0000', 'DD/MM/YYYY hh:mm:ss.ffff')))

[peterwh]

Hello,

can you use the time-function?

Kind regards

Peter

[perumal_41]

HI

tIme(time#( 01/07/2014 07:05:44.0000,'hh:mm:ss.ffff'))),'hh:mm:ss.ffff')

[Anonymous]

Hi..

I used = time(frac(date#('STARTDATETIME', ' hh:mm:ss.ffff'))) but its not working please help me...

[sivarajs]

subfield(date,' ',2)

[anbu1984]

You dont need to add quotes around field names

= time(frac(date#(STARTDATETIME, 'DD/MM/YYYY hh:mm:ss.ffff')))

[Anonymous]

Hi..

   Thax for your replay i got it..

Regards,

Chandini.G

[anbu1984]

Attachment is missing