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 Formula - Using < and cell reference
Forum rules
The Jet Reports Community forums are not a guaranteed support medium. Official support for Jet Reports is available only through the support desk at http://support.jetreports.com. Staff responses to posts on the forum are not guaranteed.
The Jet Reports Community forums are not a guaranteed support medium. Official support for Jet Reports is available only through the support desk at http://support.jetreports.com. Staff responses to posts on the forum are not guaranteed.
2 posts • Page 1 of 1
Date Formula - Using < and cell reference
by barbarar@spenco.com on Wed Mar 10, 2010 3:35 pm
- barbarar@spenco.com
- Posts: 5
- Joined: Thu Apr 03, 2008 1:43 pm
Re: Date Formula - Using < and cell reference
by bArT on Thu Mar 11, 2010 6:11 am
Hi,
you are looking for =NP("DateFilter";;$B$2) function.
BR
you are looking for =NP("DateFilter";;$B$2) function.
BR
- bArT
- Posts: 8
- Joined: Thu Apr 03, 2008 8:04 am
2 posts • Page 1 of 1
Who is online
Users browsing this forum: No registered users and 2 guests