I just wondered if it was possible to concatenate Strings, DateTime and Number fields into a single string?

 

I have found how to concatenate Numbers & strings but not dates.  Would the only way be to use a separate formula to convert the DateTime into a string and then use that in the concatenation or is there an easier way?

 

Thanks in advance!

 

James

I usually do this with dates:

 

to_text({datefield}, 'yyyyMMdd')

 

And this with numbers:

 

right('000'+{numberfield}, 3)

 

(This assumes the number's max value is 999 and that it can't be negative.  You can modify it for larger numbers.)

 

-Dell

 

 

James