Crystal Reports-display combined date/order number

I am trying to display a field which combines an order-number and an order date.  That is easy enough, using a formula to combine them.  However the problem is that, before combining them, I want to change the date (which is in DATE-TIME format) to just date (i.e. mm/dd/yy).  After changing it, I want to combine the date-only field with the order number for the report field.  i have been trying all kinds of things with no luck.
Your help is appreciated!!
Who is Participating?
peter57rConnect With a Mentor Commented:
if ordernumber is number then you can do..

Totext({table.OrderNumber},0,"") & Totext({table.OrderDate},"MM/dd/yy")
UnifiedISConnect With a Mentor Commented:
This will create the date as a string:
CSTR(MONTH({Command.t_invd}), 0) + "/" + CSTR(DAY({Command.t_invd}), 0) + "/" + RIGHT(CSTR(YEAR({Command.t_invd}),0), 2)
Just add the order number and change out my date field for yours


Create a text box and drop your date field and order number field in it (separated by a space).  Then you can format the date field to your mm/dd/yy format.
mbroad02Author Commented:
The ToText formula worked perfectly!!  thanks
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.