I have a date opened field and  a date closed field.

I need to select those records that have a closed date<= 30 days of the created date.

 

I have tried everything I know of and then some.

 

I am sure it is a very simple calc. and there are functions that are available.

 

Any help at this point will be HUGELY appreciated.

 

quick question...  I am trying to do the following and I keep getting a year mjust be between 1 and 9999 error.

 

 

if  (invoice date) In AGED0to30Days then invoice amt

 

 

my inovice date is an int data type and formated as 20091202.  any ideas on how I can get this to work.  I know I will probaly need to convert the inovice date field, but I am drawing a blank on how.

 

Thanks for your help.