Separate time from date

[cscherer]

Hello,

I want to separate a field which is in this form:

11.01.2012 09:53

into two fields:

date:

11.01.2012

time:

09:53

I tried time() and makedate(), but they don`t work.

Could you please help me?

Thank you in advance,

Clemens

[Anonymous]

use date(field)-it will give u the date

use time(field) - gives u the time

[cscherer]

Hello,

thx, but this doesn`t work.

I tried left(date, 10), this seems to work.

thx for your help

reg,

c.

[#4]

To remove the time and preserve as a date field, assuming your field is called InputDate, use:

Date(Floor(InputDate))

To get just the time, use:

Time(InputDate)

[cscherer]

thanks for the answer, i`ll try it!