⚠ In case you've missed it, we have migrated to our new website, with a brand new forum. For more details about the migration you can read our blog post for website migration. This is an archived forum. ⚠

  •     

profile picture

Change date format in relation_n_n Name String

Started by Timti, 02 December 2019 - 15:13 PM


Timti

Timti
  • profile picture
  • Member

Posted 02 December 2019 - 15:13 PM

Is it possible to change the format of {Geburtstag}?

$crud->set_relation_n_n(
'Zusatzpersonen', 
'Relation_Mietvertraege_Personen', 
'Personen', 
'Mietvertraege_ID', 
'Personen_ID', 
'{Obj_Nr} ({Name} {Geburtstag})', 
'priority');

Maybe with PHP:

date_format($date,"Y/m/d H:i:s");

 Or with SQL:

FORMAT (getdate(), 'dd-MM-yy') as date

Thanks 4 your help