Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
use date(field)-it will give u the date
use time(field) - gives u the time
Hello,
thx, but this doesn`t work.
I tried left(date, 10), this seems to work.
thx for your help
reg,
c.
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)
thanks for the answer, i`ll try it!