data format and databasejoin

[germanoalves]

I'm using a field of type databasejoin to list a date and time table. However, the table is saved in Y-m-d format and I need it to be listed by databasejoin in d-m-Y format. How can I apply this adjustment?

Thanks!

 

[juuser]

If you mean that you want the label displayed in different format then add the following to "or Contact label" field in databasejoin element settings:
DATE_FORMAT({thistable}.your_date_element,'%d-%m-%Y')

 

[germanoalves]

perfect @juuser ! Thanks!!!