DB join element with concat date

[deant]

Hi,

In dbjoin element I set concat to display two lables one of them is date. Is some how posibile to show date without time eg. 2020-03-27?

Thx

 

[troester]

This is MySQL, google for date functions.
Something like DATE_FORMAT(your-date-column,'your-date-format')

 

[deant]

Troester thanks...it works.
Here is example how to setup element If some one needs

{thistable}.element_1, ' -> ' , //delimiter
DATE_FORMAT({thistable}.element_2, "%d %m %Y")