copying and clearing Date fields

[wizcoder]

I need a script to copy a date field to another date field and to clear the rest

of the date field.

I am using cut and paste it works but sometime the validation dialog pops up.

Clearing date field leave a ? using setfield, how to get blank without activating the validation.

[LaRetta]

Hi wizcoder,

You need to blank date fields using TextToDate("")

So your script would be:

Set Field [secondDateField, FirstDateField]

Set Field [FirstDateField, TextToDate("")]

I can't imagine what validation error you are getting!? Scripts override field validations even at the system date level (and that's why you get the ?). What does the Message say?

You may have a data mis-match so be sure both fields are date format and then use the above script and you shouldn't have any problems regardless.

LaRetta

[wizcoder]

Its works!

Thanks LaRetta