NULL values in Custom Date field

[Scott I]

Is it possible to insert a null/empty value into a task-level custom date
field? I'm trying to drive a custom date as follows:

iif([Flag1],[Finish],NULL)

I will then need to roll up the value to a project level field.

The part that is causing the problem is the "else" clause. I'm not able to
get the formula to just let the custom date field be empty if Flag1 is false.

 

[JulieS]

Hi Scott,

No sorry. Date fields either have a date or "NA". You could use a
text field instead of the custom date field.

I hope this helps. Let us know how you get along.

Julie
Project MVP

Visit http://project.mvps.org/ for the FAQs and additional information
about Microsoft Project

 

[Jack Dahlgren]

Null is not a recognized value for a date field. This should work though:

IIf([Flag1],[Finish],"NA")

You can only roll up to the project summary task.

-Jack Dahlgren
http://zo-d.com/blog

 

[JulieS]

Thanks for the correction Jack. I should know better than to post
without testing
Julie

Null is not a recognized value for a date field. This should work
though:

IIf([Flag1],[Finish],"NA")

You can only roll up to the project summary task.

-Jack Dahlgren
http://zo-d.com/blog

Is it possible to insert a null/empty value into a task-level
custom date
field? I'm trying to drive a custom date as follows:

iif([Flag1],[Finish],NULL)

I will then need to roll up the value to a project level field.

The part that is causing the problem is the "else" clause. I'm not
able to
get the formula to just let the custom date field be empty if Flag1
is false.

 

[Scott I]

Thanks, works perfectly.

Null is not a recognized value for a date field. This should work though:

IIf([Flag1],[Finish],"NA")

You can only roll up to the project summary task.

-Jack Dahlgren
http://zo-d.com/blog

Is it possible to insert a null/empty value into a task-level custom date
field? I'm trying to drive a custom date as follows:

iif([Flag1],[Finish],NULL)

I will then need to roll up the value to a project level field.

The part that is causing the problem is the "else" clause. I'm not able
to
get the formula to just let the custom date field be empty if Flag1 is
false.