I have a date field, Date, I want to be filled in with todays date if someone fill in a name in another field, Name. To do this I have made a calculation with one If case

code:

---

If( Name <> ""; Today; "")

This worked when I had the date in a text field but now, when I changed it to a date field, it don't understand what to put in the field if there is no name in Name. If there is no name FM puts a "?" in the field. This most be because "" is a text command, but how do I do to say no date?

//Henkan

Hi, try this out instead.

It uses Status(CurrentDate) as opposed to Today.

If( Name <> ""; Status(CurrentDate); TextToDate(""))

HTH

Thank's Andy!

It was the last part TextToDate("") that fixed it.

I still use the Today function, is there any perticular reason that I should use the Status(CurrentDate) function instead? Is that function better in any way?

//Henkan

The today function was from an older version.

status(currentdate) is more stable. Better to use this i have found.

glad that it works ok though.

always happy to help