Date/Time Functions 1

[itflash]

Hi all

I have a....
form with a data environment (de).
grid bound to a table in the de.

My grid displays a date/time field from a table.
However, I only want to display the time element.

Is there any way to do this for a column in my grid?


Thanks

 

[jackstrawn]

Maybe I'm missing something but ...

IF your field contains DATETIME() then TIME(fieldname) should return the time.

Works for me in the Command Window. Did not try in a form.

Jack

 

[itflash]

thanks for the reply

my grid is bound to a table
the control source is set to the field, but i cannot put a command in the control source

 

[chpicker]

Try putting this as the ControlSource for the column:
[tt]
ttoc(myTimeField,2)
[/tt]
Substitute your Datetime field instead of "myTimeField".

Ian

 

[itflash]

nice one