VBBRett
asked on
How do I do a search and replace in Crystal Syntax?
I am looking to get a search and replace at a specific location in Crystal Syntax. I have a database spitting out records stating 01/11/A6, but I want to be able to convert 01/11/A6 to a date that says 01/11/06. Can anybody help me please?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Yes, thank you. I think i was looking for the following
Replace({YourDataBaseField }, '/A', '/0')
But thanks anyway. 500 points for you!
Replace({YourDataBaseField
But thanks anyway. 500 points for you!
ASKER