how to look for a date in one table within a range in another tabl

  • Thread starter Thread starter Gab
  • Start date Start date
G

Gab

iif [date1] in [date2] - 60 days, "Y" ,"N"
i need to find the first date within the second date - 60 days and then flag
it as N otherwise N,
any ideas?

thanks
 
Try:
([date1] Between [date2] And [date2]-60)

I'm not sure if that's what you want, but it will return True (-1) if found,
False (0) if not, or Null (if either field is null.) You can then format the
result to show a Y or N if you wish.
 
Back
Top