Date not correct

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

thks

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.

2 Likes

Thks Steve, it runs ok!

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

1 Like