Expression troubles

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
 
B

Brian Camire

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))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top