Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi community,
I have an inline load of month and year that I use for selection in part of my document. It has an odd format with '01-FEB', '02-MAR' being the month.
What I'd like is for the list box of this inline loaded month and year to influence the selection of a different field called QBperiod that has values '01', '02' for march and feb.
Also a bonus would be if the selection of 2013, '02-MAR' would select QBPeriods, '01', '02' and all of the previous years like 2012, 2011...
Hi,
Then you need to load inline as
Load *,Left(Month,2) as QBPeriods Inline
[Month
01-FEB
02-MAR
.
.
.
.
.];
Celambarasan