Creating a date field

[huskerfan1]

I have a year, month, and date string fields that I want to put together into a date. Some of the data in the fields is junk. How do I write a formula that takes into account that some of the data won't produce a valid date due to the junk?

 

[LMCRYER]

need more info -define "junk" ? numbers? letters? gibberish?

lmc
cryerlisa@hotmail.com

 

[kenhamady]

Try something like:

If Val({Monthstring}) in 1 to 12 and
Val({Daystring}) in 1 to 31 and
Val({Yearstring}) in 1950 to 2050

then Date (Val({Yearstring}),
Val({Monthstring}),
Val({Daystring}) ) Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guide to using Crystal in VB

http://www.kenhamady.com/

tek@kenhamady.com

 

[huskerfan1]

Thanks. It worked