Crystal Reports XI formula problem
Hi everyone,
It's been an while since I have used Crystal Reports and am having trouble with a formula...
If paid by2/26/2011 12:00:00AM is what I see when I run my program, I don't need the time, just the date.
Here is the formula:
"If paid by" & DateAdd ("d",10,{TransactionTable.InvoiceDate})
Thanks for the help
Software/Hardware used:
Crystal Reports XI
It's been an while since I have used Crystal Reports and am having trouble with a formula...
If paid by2/26/2011 12:00:00AM is what I see when I run my program, I don't need the time, just the date.
Here is the formula:
"If paid by" & DateAdd ("d",10,{TransactionTable.InvoiceDate})
Thanks for the help
Software/Hardware used:
Crystal Reports XI
ASKED:
February 25, 2011 8:41 PM
UPDATED:
February 25, 2011 11:20 PM
Answer Wiki:
Try using the <a href="http://publib.boulder.ibm.com/infocenter/radhelp/v7r5/index.jsp?topic=/com.businessobjects.integration.eclipse.designer.doc/html/topic728.html">DateValue or CDate functions</a> to remove the time part.
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
