Expression troubles

  • Thread starter Thread starter Dennis
  • Start date Start date
D

Dennis

I am trying to make an expression that produces an * when
by the 26th of that current month, 90 days or more will
have passed from the date in the field [Date in Grade]
Below is what I came up with and it produces an * but not
in the correct time frame. Help!

90Day: IIf([Date in Grade]+80<'61','*')

Thank you,
Dennis
 
You might instead try setting the criteria for your "Date in Grade" field to
an expression something like this:

<=DateAdd("d", -90, DateSerial(Year(Date()), Month(Date()), 26))
 
Back
Top