In v2 I can alias a calculation or column formatting and display the result using the alias as the field name. In v3 this fails.
Some examples:
I format TIME column to get rid of seconds:
Code: Select all
time_format(pic_time,'%H:%i') as pic_time
I derive a value:
Code: Select all
odo_unit*(if(odo_end=0,odo_start,odo_end)-odo_start) as km
I simply alias a column:
Code: Select all
odo_start_date as mydate
Any suggestions would be welcome - does v3 ignore column aliases in subform?