>Hi Ken.
>
>>I'd like my Stonefield reports to omit the seconds and century when printing datetime fields and to use a 24 hour format. How can I do this so that the filter dialogs and the report itself uses these settings?
>
>I can't figure out how to display DateTime fields that way either. No matter what I use as the format expression, TRANSFORM(datetime(), '
') always gives the complete date time. The only thing I can think of right now is to create a calculated field that uses a UDF that returns a string formatted the way you want.
>
>Doug
SET SECONDS OFF
SET HOURS TO 24