GetFieldSelection error

[sutoniusahadong]

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

[jonathandienst]

What are you trying to do and what is the error? GetFieldSelections is probably not the best way to do it.

[sutoniusahadong]

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