hh mm ss

[EscapeUK]

How do I change the hh:mm:ss to 00:00:00 I ham using a date time filed (no choice)

eg

from
12/01/2001 12:01:23

to
12/01/2001 00:00:00

 

[clawton]

Try setting up a function with the following :

DateTime( Date( {DateTime Field} ), Time(0))

For example, to get todays date at midnight :

DateTime(Date(CurrentDateTime),Time(0))

Hope it helps...


Chris Lawton
Chris.Lawton@GoldMine.com

 

[EscapeUK]

How about changing

from 12/01/2001 12:34:12

to

12/01/2001 22:30:00

 

[dcm]

EscapeUK: The DateTime function takes up to 6 arguments so you can create if you wish a return value by supplying Year, Month, Day, Hour, Minutes & Seconds. Alternatively if all you want to change is the time then try using DateTime({whateverdate},Time(Hour,Minute,Second)) David C. Monks
david.monks@chase-international.com

http://www.chase-international.com

Accredited Seagate Enterprise Partner