Solved

Crystal Reports-display combined date/order number

Posted on 2009-07-15
3
291 Views
Last Modified: 2013-11-15
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!!
0
Comment
Question by:mbroad02
3 Comments
 
LVL 18

Assisted Solution

by:UnifiedIS
UnifiedIS earned 100 total points
ID: 24860558
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

OR

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.
0
 
LVL 77

Accepted Solution

by:
peter57r earned 400 total points
ID: 24860577
if ordernumber is number then you can do..

Totext({table.OrderNumber},0,"") & Totext({table.OrderDate},"MM/dd/yy")
0
 

Author Closing Comment

by:mbroad02
ID: 31603786
The ToText formula worked perfectly!!  thanks
0

Featured Post

Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

1. Set up your parameter at the report level as usual, check the box Multi-value, and set the Data Type to String 2. Set the Stored Procedure Parameter to varchar(max)  --<---- This part here is the key to it's success Example:    @cst_key var…
Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
Microsoft Active Directory, the widely used IT infrastructure, is known for its high risk of credential theft. The best way to test your Active Directory’s vulnerabilities to pass-the-ticket, pass-the-hash, privilege escalation, and malware attacks …
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question