Skip to Content
0
Former Member
Jan 25, 2011 at 08:45 PM

Explicit name error in Universe Designer

680 Views

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