Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Dynamic List Formatting

Status
Not open for further replies.
epoh

epoh

IS-IT--Management
May 8, 2006
73
US
How can I format a Dynamic List so only the date shows as a date instead of a date & time?
 
Sort by date Sort by votes
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
 
Upvote 0 Downvote
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
 
Upvote 0 Downvote
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?
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

jchewsmith
  • Locked
  • Question
Formatting an embedded field in Crystal 2016 Support Pack 5 1
Replies
3
Views
376
BobSuruncle
BobSuruncle
PJ222
  • Locked
  • Question
is date within any date range in a dynamic array of date ranges
Replies
1
Views
275
PJ222
PJ222
GCL2007
  • Locked
  • Question
Formatting hyperlink on exported document
Replies
0
Views
142
GCL2007
GCL2007
lm1340
  • Locked
  • Question
Build comma separated list with output from formulas 1
Replies
5
Views
359
lbass
lbass
n2nuk
  • Locked
  • Question
formatting a date within a concatenated field 1
Replies
8
Views
243
n2nuk
n2nuk

Part and Inventory Search

Sponsor

Back
Top