This content has been marked as final. Show 3 replies
I need take the Max Date of a table (Master Cube table below) and use that date in my where clause for another table.
I know my script is NOT right below. But how do I get the vGLDATE field from the Master Cube into the Where clause of my Current Budget table
max(GLDATE) as vGLDATE
Where vGLDATE < BUDGET_DATE;