Date Validation

[NB]

I want to compare between custom dates and i am getting circular
dependency error. Can anyone tell me what is wrong with this formula?


IIf( [Start1] > [Finish1], "Invalid Date", [Start1] )


Thanks

NB

 

[Jan De Messemaeker]

Hi,

IMHO a circular dependency error has nothing to do with a formula (which
looks OK, BTW)

 

[NB]

Let me explain then what i am trying to do here. I need to validate
that start date should not be greater then the finish date. If the user
does that then i need to pop a message telling them to change the date.
How can i do that? please advice.

Thanks in advance.

 

[Rod Gill]

What field is this in? If it's in a Date field, then you can't display text.
If it's in a Flag field it can only display Yes or No

 

[Jan De Messemaeker]

Hi,

Since you posted this in the VBA group, and to cate a popup you will need
VBA (cannot be done with formula) I suppose you can live with a VBA
solution.
Here is an idea for (some of) the code:

Sub St1Fi1()
Dim Job as task

For each job in activeproject.tasks
'alternatively ... activeselection.taks if you want to limit the scope)
if not job is nothing then
if job.start1>job.finish1 then
'Inputbox or MsgBox function here
'following treatment here
end if
end if
next job

End sub

Hope this helps,