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

Hi,

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

--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
http://users.online.be/prom-ade/
+32-495-300 620
"NB" <nerdbeans@gmail.com> schreef in bericht
news:1139506617.419735.317090@z14g2000cwz.googlegroups.com...
> 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
>

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.

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

--

Rod Gill
Project MVP
Visit www.msproject-systems.com for Project Companion Tools and more


"NB" <nerdbeans@gmail.com> wrote in message
news:1139506617.419735.317090@z14g2000cwz.googlegroups.com...
>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
>

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,





--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
http://users.online.be/prom-ade/
+32-495-300 620
"NB" <nerdbeans@gmail.com> schreef in bericht
news:1139514839.800688.53950@g47g2000cwa.googlegroups.com...
> 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.
>