Lookup wizard (format)

This topic is locked

Lookup wizard (format)	7/28/2008 12:24:19 PM
PHPRunner General questions
G gbhmayer1 author I am formating a custom expression in display field in the lookup wizard: concat( 'FROM ',dt_inicial,' TO ',dt_final) but the date fields (dt_inicial/dt_final) shows in the MySQL Format (Y-M-d). How to format it to d/M/Y in this case?


J	Jane 7/29/2008
	Hi, use MySQL functions to construct correct date: http://dev.mysql.com/doc/refman/5.0/en/dat...-functions.html Here is a sample: concat( 'FROM ',DAYOFMONTH(dt_inicial),'/',MONTH(dt_inicial),'/',YEAR(dt_inicial),' TO ',dt_final)