Working with String values and using CDate

building reports crystal reports
1

Hello,

I’m using CDate({Table.FldVal}) to pull out dates from a String value.
It works flawlessly, but as I’m going thru various pages of data I get prompted with “Bad Date Format String” error.

Under further review, I figured out the Table.FldVal is not always the same format. About 99% of the time it pulls the date correctly, but sometimes the FldVal has something like “UK - Unknown” or “N/A” or other various phrases that don’t contain a date are messing it up.

Is there a way to look at Table.FldVal first and if it’s like 01/01/1900 then show the CDate otherwise just put N/A or 0 or something that tells me it cannot compute?
I’m guessing there is a way to do this, but I’m unfamiliar with the syntax of doing this.

Any info would be greatly appreciated.
Thanks!

cor_dog2 (BOB member since 2015-01-22)

2

Nevermind…figured it out. :smiley:

I used:
IF IsDate({Table.FldVal})
THEN CDate({Table.FldVal})

Hope it helps someone else.

cor_dog2 (BOB member since 2015-01-22)