Concatenate "DateTime" with "Reference" Text

[Eduardo_Dalcin]

Hi folks!

How do I concatenate a DateTime column together with a Reference column to another table, with a Text Column. There is any way?

Thanks in advance!

[anais-grist]

Hi Eduardo!

I made an example here: Concatenate Date + Ref + Text

You an use the format() function to format the different column types as a string. The formatting is between the "quotes". The empty squiggly bracket {} are placeholders for the columns in the function. The columns apply to the {} respectively.

[Eduardo_Dalcin]

Work Perfectly! Thanks!