Date not correct

[J_jvs]

Hi team
why date change when i want to use it in a concatenate expresion?

thks

[Steve · Accepted solution]

In your CONCATENATE() expression, wrap the reference to the Date column with TEXT():

CONCATENATE(
  TEXT([dia),
  [usuari]
)

The TEXT() function will apply the column’s configured formatting preferences and the broader localization settings.

[J_jvs]

Thks Steve, it runs ok!

CONCATENATE(
TEXT([dia]),
[usuari]
)