Pivot Table

[#1]

hi guys,

need help

how can i fill up the text boxes with '1'

the expression is used is simple; if(current date= Start Date, 1 , if current date= End Date,2)

Regards

[Gysbert_Wassenaar]

Maybe if([PTL Start Date]=makedate(Year,Month,Day),1,if([PTL End Date]=makedate(Year,Month,Day),2))