I have a date field in my database that is broken out into Century, Year, Month, and Day. They are all 2 position numeric. How can I string together the fields to have a resulting field look like this:
I need to have the slashes (/) in-between the month, day, and century as shown above. I have tried to use the string, and concatanate functions, but have been getting errors. How can this be accomplished? Any help would be greatly appreciated!!
What sort of database? What is the data type for the field? Are you sure it's just one field in the DB, not separate fields? If it is all shoved into one field, what's the format for the data? Would March 15th, 2004 look like: 20040315?
Thank you so much for the help. It worked except for one thing. The fields coming from the DB2 enviroment are defined as numeric 2 positions with no decimals. When Crystal imports them, it automatically adds a 2 position decimal to the field. When building the formuls, I was expecting a result like 01/01/2004, but instead I get a result of 1.00/1.00/20.0004.00. How can I make Crystal not add a two position decimal to the numeric fields coming in? I also noticed that Crystal is doing this to all fields that are numeric with no decimals. It automatically put a two position decimal on the field in Crystal.