Greater than or equal to date

[stryder09]

I have a start date for a project and a determined end date based on your criteria (ex. 6 weeks or 42 days) The end date is calculated using the following.



Field Name is ChallengeEndingDate

=DateAdd("d",[ChallengeLength]*7,[ChallengeStartingDate])

Every day, a log is filled out and entered into the system, I would like a fielld to be populated automatically to say Passed or Failed or N/A, depending on the current date. If the date is before the ending date then N/A will appear, if on or after the ending date depending if criteria was met I want it to say Pass or Fail.

I thought maybe something like the following but it doesn't work.

=IIF([TodaysChallengeDate]>[ChallengeEndingDate] Or [TodaysChallengeDate]=[ChallengeEndingDate],([Challenger1GoalWeight]-0.1)<[Challenger1Weight],"Passed","Failed")


Any Help would be appreciated

[ajetrumpet]

I have a start date for a project and a determined end date based on your criteria (ex. 6 weeks or 42 days) The end date is calculated using the following.

Field Name is ChallengeEndingDate

=DateAdd("d",[ChallengeLength]*7,[ChallengeStartingDate])

I understand that.

Every day, a log is filled out and entered into the system, I would like a fielld to be populated automatically to say Passed or Failed or N/A, depending on the current date. If the date is before the ending date then N/A will appear, if on or after the ending date depending if criteria was met I want it to say Pass or Fail.

this I cannot follow. Care to expand a little more??