Explicit name error in Universe Designer

[Former Member]

Hi all,

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

thanks,

Tyler

[Former Member]

Try this

current query: select date(693595.8+GUPSLSDAYS.JULNDAY) AS DATEMODIFIED from IVOPOHD

AK