PDF file shows more than the related rows

trying to create a PDF from a selection of data pertaining to WEEKNUM, but shows all data regardless of the data I think I have selected

PDF if expression: 

<<If: (COUNT(SELECT([Related TimeCards][ID], [WeekNum]=WEEKNUM([Created timestamp])))>0)>>

then filtered to PDF table through this: 

<<START:SELECT([Related TimeSheets][ID],[WeekNum]=WEEKNUM([Created timestamp]))>>[the days of the week per column] <<END>>

but it is pulling all created data regardless of the WEEKNUM(Created timestamp] that i would have thought would have selected weeknum I want to view.

any help would be appretiated

0 2 57
2 REPLIES 2

That would suggest that the [WeekNum] is the same as WEEKNUM([Created Timestamp]) for all records. You're saying that is not the case? Can you provide an example of the data?

Der Weeknum-Ausdruck zum Abrufen von Daten für die aktuelle Woche lautet: WEEKNUM([Timestamp_ID])= WEEKNUM(TODAY()-1)

Top Labels in this Space