Null value in a date calculation field

[kayp]

I created a date calculation field to track changes to another field with the following calculation:

If (IsEmpty(Status),"",Status(CurrentDate))

This works, except that when the Status field is null, the calculated date field contains a question mark.

Is there any way I can just set the date field to null (i.e. no value)?

Thanks, Kay

[Lee Smith]

If (IsEmpty(Status),"",Status(CurrentDate))

If(IsEmpty(Status), 0,Status(CurrentDate))

You need to make your result Text Also.

I prefer a Case Statement over the If for two reasons.

I can read them and write them easier.

c_Status

[Ender]

How about:

Case(not IsEmpty(Status), Status(CurrentDate))

This leaves the field blank when status is empty.

[Lee Smith]

Oops, good catch Ender,

My eyes are playing tricks on me again. I could have sworn that Kay ask how to display a 0 instead of a "?" mark, else I would have left the stupid 0 out of the calculations in the first place and just amended hers.

Using the Calculation provided by Ender, you can leave the field a date.

in order to leave the field a Date with the If Statement, you would have to alter it like this:

If(not IsEmpty(Status), Status(CurrentDate), TextToDate(""))

Lee

[kayp]

Thanks, folks. The TextToDate("") did the trick and allowed me to both leave the field as a date type and reset the field to null.

Kay