This topic is locked
[SOLVED]

 DATE VALUE AS YEAR

8/30/2011 10:24:57 AM
PHPRunner General questions
C
ckapote author

HI ALL ,
I HAVE A DATE FIELD I.E. 19/03/2011 AND I NEED TO DISPLAY IT AS YEAR INSTEAD I.E. 2011 TO GET REPORTS PER YEAR.
PLS HELP
FYI I USE MDB ACCESS FOR DATABASE

C
cgphp 8/30/2011

Set the date field in the List page as Custom (http://xlinesoft.com/phprunner/docs/_view_as__settings_custom.htm) and enter this code:

$value = date("Y",strtotime($value));
C
ckapote author 8/31/2011



Set the date field in the List page as Custom (http://xlinesoft.com/phprunner/docs/_view_as__settings_custom.htm) and enter this code:

$value = date("Y",strtotime($value));




Thank you very much!