Check dates against value list

[Rob Evans]

I'm having trouble defining a calc field to warn me if the date I just scheduled for a new project is among a value list of dates I've previously defined as not be scheduled. Thanks in advance.

[AHunter3]

Dates being what they are and textstrings being a somewhat different thing, it's useful to know what format your dates are in your value list.

 

3/25/06? 03/25/06? 25/03/06? 3-25-06? 03/25/2006? Feb 3, 2006? etc

 

So adjust the following for the format actually used in your value list, but where format is "3/25/06" and your Value List is named "Unscheduled Dates", try this:

 

Case(PatternCount(ValueListItems( Get(FileName), "Unscheduled Dates"), Month(DateField)&"/"&Day(DateField)&"/"&Right(Year(DateField), 2))>0, "Yep that date's in the Value List", "Nope, that one's not in there yet")