joining dates and numbers into one string

[Shannon2008]

This is probably a simple thing, but I can't seem to come up with the solution. I need to join three fields to print in a text file as one continous string and the date field must be reformatted to match the specs of the file.

Example

123456789 10/13/2009 44455

The result I need is:

1234567892009101344455

Any suggestions?

 

[MzKitty]

make a formula field and code as:

cstr(field1) & cstr(field2) & cstr(field3)

You will have to move the date into another formula and format it to YYYYMMDD before you do the above.

Cathy

 

[Shannon2008]

Thank you MzKitty! Problem solved.