>Month1 is a number field in a table. I want to select this field in a SQL select statement but to change the field name returned with a corresponding date from an array of dates. I know that I have to convert the date into a character string so it can be used as a valid column returned by the SQL statement.
>
>Example Select code, department, month1 as dtos(laMonths[1]) from file1 into cursor file2.
>
>Can this be done ?

lcFieldName = "_"+dtos(DATE())&& Field names can not start with a number

Select code, department, month1 as &lcFieldName;
 from File1;
into cursor file2
  
BROWSE NORMAL