Jump to content

copying and clearing Date fields


This topic is 7581 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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.

Link to comment
Share on other sites

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. grin.gif

LaRetta

Link to comment
Share on other sites

This topic is 7581 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.