Crystal Report have an Extract String but need to get it in date format

I have the following and it works fine, but I need it to be in a date format 01/08/2018 example

(ExtractString({MASTER_LABEL.FG_LOTNO},"-","-"))
Tammi RushAsked:
Who is Participating?
 
Tammi RushAuthor Commented:
It currently produced 010218 and yes I tried Cdate and it didn't work.  I need it to be 01/02/2018
0
 
mlmccCommented:
What does it produce now?

Have you tried using the CDate function?

mlmcc
0
 
mlmccCommented:
Try

Picture(ExtractString({MASTER_LABEL.FG_LOTNO},"-","-"),"xx/xx/xx")

mlmcc
0
 
Tammi RushAuthor Commented:
Perfect!
0
 
mlmccCommented:
Why did you accept your comment as the answer
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.