Dynamic List Formatting

[epoh]

How can I format a Dynamic List so only the date shows as a date instead of a date & time?

 

[synapsevampire]

What's the source of the dynamic list, a table or a Command Object?

A command object might do so by using a CAST or CONVERT to make it just a date type, but of course this depends upon your database type.

Otherwise I think that it just uses the underlying data type.

-k

 

[epoh]

I am using a Table in a database

Data is a timestamp

CR uses picks the first value '2006-09-26 14:26:39' I would like for it to show up as '09-26-2006'

Thanks

 

[epoh]

CR uses picks the first value '2006-09-26 14:26:39' I would like for it to show up as '09-26-2006'

Is this possible?