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!

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

Converting Text to Numbers or Date fields 1

Status
Not open for further replies.

malk

MIS
Dec 12, 2000
84
US
I am using CR 8, and I am using CSV files as my data files. I have 2 strings of text that need to be other variables:
1- A string "MMDDYY" that I'd like to convert to date in the report, and use as a parameter field for date selecting.
2- a check Number String. I want to be able to run "greater then or Equal" functions on the number.
Please Help!!
 
You can convert strings to numerics with the ToNumber(x) or NumericText(str) function(s) in Crystal Reports. And you can convert numeric to string with the ToText(x) function. DateValue(number or dtring) function will work with dates. I hope this answers your question(s).
Brett Please visit my websites!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top