March 26, 2008, 01:18 PM
NelsontGet current year in a dynamic selection from a drop down box.
I'm running a fex where I am using a dynamic selection in a drop down box to get Year out of a date_dm.
Right now the fex when ran pull's in all years from the Date_DM 2004-2011 which is fine. But it alwas put's 2004 as the first selection. How do i get it have current year selected instead of the first year in the date_dm.
JOIN
GL_DETAIL_FACT.DM_TEST_GL_DETAIL_FACT.TRANS_DATE_KEY IN GL_DETAIL_FACT
TO UNIQUE DATE_DM.DM_TEST_DATE_DM.DATE_KEY IN DATE_DM AS J0
END
TABLE FILE GL_DETAIL_FACT
SUM
EFFECTIVE_TRANS_AMOUNT
BY GL_UNFORMATTED
HEADING
""
FOOTING
""
WHERE FISCAL_YEAR EQ &FISCAL_YEAR.(FIND FISCAL_YEAR IN date_dm).FISCAL_YEAR.;
March 26, 2008, 02:41 PM
Darin LeeCreate your own procedure to create the drop-down list as you want it instead of letting WF decide how it will be created. Then specify the procedure to populate it instead of the TABLE/FIELD names
March 26, 2008, 02:43 PM
GinnyJakesThe answer to this has been posted very recently.
Using a Procedure to Sort Dropdown Box ContentsAlso please update your signature with your product suite, releases, and platforms so that we may better help you.
Also, you might want to do a search on the forum or the Advanced Search before you post to see if the question has already been answered, as this one was.