# Formula Results 3

With the Experts help today I am very close to completing what I consider a complex report for me but have learned a lot and it has been fun.  I have one more question and hopefully can put this report behind me.

From a prior question this formula will give me anything in a recordset that is prior to the current month and back even into the prior years.  so essentially if the current month was April 15, 2013  this would give me  3/31/2013 back to  some date in the past like 1966 or what the recordset contains.

{JAM_DSH_OP_Open__Summary.OrderRel.NeedByDate}) < Dateserial(Year(currentdate),Month(currentdate),0)

What I need is a formula that will give me everything back from the current year.  So if this were June 4, 2013  I need all the records from 12/31/2012 and back.

My best guess would be

{JAM_DSH_OP_Open__Summary.OrderRel.NeedByDate} < Dateserial(Year(currentdate),0)
LVL 3
###### Who is Participating?

x

Commented:
if you want compare by date
{JAM_DSH_OP_Open__Summary.OrderRel.NeedByDate} < Dateserial(Year(currentdate),0,0)

other wise this is also correct

Year({JAM_DSH_OP_Open__Summary.OrderRel.NeedByDate}) < Year(currentdate
0

Commented:
try

{JAM_DSH_OP_Open__Summary.OrderRel.NeedByDate} < Dateserial(Year(currentdate),0,0)
0

IT DirectorAuthor Commented:
So I would not need month in it correct?
0

Commented:
you need to provide as Dateserial function required that parameter
0

IT DirectorAuthor Commented:
This is what I currently have.

Year({JAM_DSH_OP_Open__Summary.OrderRel.NeedByDate}) < Year(currentdate)

What I understand your suggestion to be is replace this with

{JAM_DSH_OP_Open__Summary.OrderRel.NeedByDate} < Dateserial(Year(currentdate),0,0)

am I interpreting correctly?
0

IT DirectorAuthor Commented:
The Experts have save the day!!!!!  Thanks again.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.