1. Fabrik 3.9 has been released. If you have updated Joomla to 3.9, this is a required update.
    Dismiss Notice

data format and databasejoin

Discussion in 'Community' started by germanoalves, Jun 14, 2021.

  1. germanoalves

    germanoalves Member

    Level: Community
    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!
     
  2. juuser

    juuser Well-Known Member

    Level: Community
    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')
     
    troester likes this.
  3. germanoalves

    germanoalves Member

    Level: Community

Share This Page