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?  
VBBRettAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
frodomanConnect With a Mentor Commented:
Replace({YourDatabaseField},'/A6','/06')

This formula will return the original field value but replace the A with a zero.  Is that what you're looking for?
0
 
VBBRettAuthor Commented:
anybody have the answer?
0
 
VBBRettAuthor Commented:
Yes, thank you.  I think i was looking for the following

Replace({YourDataBaseField}, '/A', '/0')

But thanks anyway.  500 points for you!
0
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.