Date formula problem

[meg99]

using 2003. I have dates I need to import from another application.
The application only stores the start or finish dates for milestones
but not both. For example, if a MS is a start MS, the date is stored
in Start. If it is a finish MS, the date is stored in Finish.

I import those dates into Date5 and Date6 respectively. Of course,
Project must have both dates and so I have a formula in Date1 and
Date2 to resolve this before I paste into the Start and Finish fields.

Example
TASK Date5 Date6
A 1/1/07 NA
B NA 2/2/07

The formula in Date1 is: IIf([Date5]="NA",[Date6],[Date5])
an alaternate formula is: IIf(DateValue([Date5]),[Date5],[Date6])
alternate formula is: IIf([Date5]<>"NA",[Date5],[Date6])
None of these give the correct value for the conditions

What I should get in Date1 for Task A is 1/1/07 and for Task B 2/2/07

What I AM getting is correct for Task A but ERROR on Task B

Anybody know what I have done wrong?

meg99

 

[Dale Howard [MVP]]

meg99 --

I believe the following formula will solve your problem nicely:

IIf([Date5]=ProjDateValue("NA"),[Date6],[Date5])

Hope this helps.

 

[meg99]

meg99 --

I believe the following formula will solve your problem nicely:

IIf([Date5]=ProjDateValue("NA"),[Date6],[Date5])

Hope this helps.

Dale,
Works great! Thanks!

meg99

 

[Dale Howard [MVP]]

meg99 --

You are more than welcome, my friend!

meg99 --

I believe the following formula will solve your problem nicely:

IIf([Date5]=ProjDateValue("NA"),[Date6],[Date5])

Hope this helps.

Dale,
Works great! Thanks!

meg99