I need to reference all dates prior to today's date in a formula
I don't know how to create a formula to use within Jet that will be equivalent to ..$B$2 (where $B$2 is today's date). In other words, all dates up to today. I am using a formula to pull today's date =np("Eval","=Today()" - found in $B$2
Keep in mind the report goes out each day.
=NL("count","Contact",,"Last Call Date",?????,"Salesperson Code",$C8,"Contact Type","customer")
Date
Votes
1 comment
-
Jet Reports Historic Posts Hi,
you are looking for =NP("DateFilter";;$B$2) function.
BR
Please sign in to leave a comment.