Combine two fields into a text field

[f0rg3tfu1]

Hello all again!

Cr 10, SQL server backend.

I have two fields that I would like to combine together in a formula. One is a date field and the other is a number field.

I would like to combine them into one field so I can group by it... EX:
Jan 31, 2004 1
Jan 31, 2004 2

Do I use the totext function?

Thanks for your help!!!

 

[bdreed35]

Try this:

ToText({table.datefield},"MMM dd, yyyy") & " " & ToText({table.numberfield},"0")

~Brian

 

[f0rg3tfu1]

Awesome... perfect solution. Thank you!