Date Validation In Text Field

Using @IsDate function will only tell you if a FIELD is in Time/Date format, not if the value is valid. To properly...

validate that a text field has a valid Time/Date value (when not originally specifying the field as Time/Date to begin with)... Convert the text value to time with @TextToTime. If invalid Time/Date, the conversion will result in nothing! @If(@Text(@TextToTime(DateField))= "";@Failure("Invalid Date");@Success)

This was first published in November 2000

Dig Deeper

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

-ADS BY GOOGLE

SearchWindowsServer

Search400

  • iSeries tutorials

    Search400.com's tutorials provide in-depth information on the iSeries. Our iSeries tutorials address areas you need to know about...

  • V6R1 upgrade planning checklist

    When upgrading to V6R1, make sure your software will be supported, your programs will function and the correct PTFs have been ...

  • Connecting multiple iSeries systems through DDM

    Working with databases over multiple iSeries systems can be simple when remotely connecting logical partitions with distributed ...

SearchEnterpriseLinux

SearchDataCenter

SearchExchange

SearchContentManagement

Close