Trygve Thayer
asked on
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.N eedByDate} ) < Dateserial(Year(currentdat e),Month(c urrentdate ),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.N eedByDate} < Dateserial(Year(currentdat e),0)
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.
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.
ASKER
So I would not need month in it correct?
you need to provide as Dateserial function required that parameter
ASKER
This is what I currently have.
Year({JAM_DSH_OP_Open__Sum mary.Order Rel.NeedBy Date}) < Year(currentdate)
What I understand your suggestion to be is replace this with
{JAM_DSH_OP_Open__Summary. OrderRel.N eedByDate} < Dateserial(Year(currentdat e),0,0)
am I interpreting correctly?
Year({JAM_DSH_OP_Open__Sum
What I understand your suggestion to be is replace this with
{JAM_DSH_OP_Open__Summary.
am I interpreting correctly?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
The Experts have save the day!!!!! Thanks again.
{JAM_DSH_OP_Open__Summary.