I've written the following query to select the date field from the GUPSLSDAYS table, and translate it to regular date format to a new derived table. I'm getting the "Each calculated column must have an explicit name." error. I realize most times the cause of this is the lack of the "AS" to give the alias column a name, however, I have that. Anyone know what's wrong?
current query: select date(693595.8+GUPSLSDAYS.JULNDAY) from IVOPOHD AS DATEMODIFIED