How to concatenate date fields 2

[walshut]

Instead of having two field columns I want to create a formula that merges the two dates "start date" & "end date" together to show "start date - end date". I have made formulas in the past to do this with names but when I try with dates I receive a error message. I set up the formula like so....

{Start Date} + " - " + {End Date}

but then recieve an error message that says....

"a number is required here" this is accompanied by the cursor sitting to the direct right of the first "

Any ideas?

 

[goranm]

Hi !

Try this:

ToText({Start Date}) + " - " + ToText({End Date})

/Goran

 

[kenhamady]

You can also add a text object and drop the fields in (format them to look the way you want them to first). 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