Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear All,
Can any body help for this error ..
=Count({$<[Valid To]={'$('>&GetFieldSelections(periode)&'-01-01)'}, [Valid From]={'${<'&GetFieldSelections(periode)&'-02-01')}>}DISTINCT [Emp No])
Tq
Toni
What are you trying to do and what is the error? GetFieldSelections is probably not the best way to do it.
Tq for your repply,
I want create table fulfillment, and the value will appear trigger from periode (current year, year -1, year -2, and year-3)
i do this to solved :
1. Create variable JAN until DEC : =date(GetFieldSelections(periode)&'-02-01','YYYY-MM-DD')
2. expresion for JANUARI is =Count(DISTINCT {<[Valid To]= {">=$(JAN)"}, [Valid From]={"<=$(FEB)"}>} [Emp No])
Tq
Toni