0

Date filter seems to be off by a day?

in cell C3 I have this

=NL("rows","Quotes - Original",{"Trip Departure Date"},"Trip Departure Date", "2010-01-01..")
In cell D3 I have this:

=NF(C3,"Trip Departure Date")
It is returning Trip Departure Dates from 12/31/2009 and above. I am not sure why this is happening. Also can anyone explain how the date/number works in Jet Reports? I may be getting confused by this if I am understanding this wrong. To me, it is converting the date, 2012-01-01 to the number of days past january 1 1900, and then running the code on that number but I am not sure why it is comparing as a day before the entered date.

11 comments

Please sign in to leave a comment.