Script step to remove date?

[phljoe]

Hello,

In Scriptmaker, I'd like to insert a line in a script to remove a date from a date field. I would think I should use the "Set Field" script step, specify the date field I want to clear, and then enter "". However the calculation result must be a date so the field displays a "?" How can I rewrite this to simply get the date field to be empty?

Thanks.

[mr_vodka]

Try Set Field [ DateField, DateToText( "" ) ]

[Lee Smith]

For this, I would just use the Clear Script Step.

Clear [ AnyDate ] [ Select entire contents ]

Lee

[LaRetta]

Keep in mind that the field must be present on a layout in which the Clear[] script-step is activated (at least in vs. 7). Otherwise it won't clear the field. I don't believe this is documented in FM Help either ...

A straight Set Field [ dateField ; "" ] works in vs 7/8 now. It's a wonderful improvement over prior versions.

[Lee Smith]

Good point. I don't think this has changed either.

Lee

Long overdue, and thanks for point this out to me. I feel like a sponge with v8. Best version yet.

Edited December 14, 2005 by Guest
v8 remark

[phljoe]

:

Hi Mr. Vodka!

Thank you. This worked. I wouldn't have thought of that since "Date to text" seems to contradict the calculation qualifier that result must be a date. I greatly appreciate your response.

[phljoe]

Lee,

By "AnyDate" I assume you mean the date field I am trying to clear. If so, that didn't work. Thanks for the response, though.

[Lee Smith]

AnyDate is my sample date field name. You would just substitute the name of your own Date Field for it.

The only reason that this [color:red]Would Not work, is if the field is not on the layout that you're on when using the script. (see LaRetta post )

Lee

:cool: