Validation regex in KB not working

I am referring to KB 45818, and the validation regex for the date seems to show today as an invalid date!!
Can someone else verify this for me. This regex was working fine for the past month or so without any problems.
I am referring to:

<ruleset name="Interwoven Information Page">
<description>
Capture announcement to pair with date,weather,stock
</description>
<item name="Announcement">
<text size="10"
maxlength="10"
validation-regex="((((01|03|05|07|08|10|12)-((0[1-9])|([12][0-9])|(3[01])))|((04|06|09|11)-((0[1-9])|([12][0-9])|(30)))|(02-((0[1-9])|(1[0-2])|(2[0-8]))))-(19|20)[0-9][0-9])|(02-29-(19|20)(((04|08))|((2|4|6|8)(0|4|8))|((1|3|5|7|9)(2|6))))"
required="t" />
</item>
</ruleset>

Thanks- The URL to the KB is --

https://support.interwoven.com/kb/kb_show_article2.asp?ArticleID=45818

Find more posts tagged with

Comments

Adam Stoller

What date string are you using that's failing?

12/02/2003
02/12/2003
12-02-2003
02-12-2003
2003-02-12
???

--fish
(Interwoven Senior Technical Consultant)

JackIntheBox

I guess I misspoke. All the dates from 02-13-2003 to 02-19-2003 seem to fail. I am using the format ( MM-DD-YYYY)

Thanks

Adam Stoller

Okay - let's get a few more parameters here:

What version of TeamSite / TeamSite Templating (including SP, patches)?
What platform?
What browser / browser version?

Are you using the browser-based of java-based Templating client?

The regex, as written, appears to work just fine in a stand-alone Perl script - for whatever that's worth.

--fish
(Interwoven Senior Technical Consultant)

JackIntheBox

I am on Solaris, TS 5.5.2 . And we use browser based templating. I realized that the regex failed when we were testing new templates this morning -- I am really perplexed.

Internet Explorer 5.5
iwserver: 5.5.2 Build 10716 Interwoven 20020811

Thanks.

Migrateduser

There are enough issues with date validation that it seems like it should be built into the base templating product (something like the calendars I use to book flights and rental cars would be pretty handy). Does anyone have something that does this? Not a callout because the CGI performance is too bad - something that can be embedded directly into the template?

I have attached some date validation code. I am not totally sure of the algorithm for leap year but I think it is close, and I just made some changes that I haven't tested but it might work. There is also something in there you can use to ensure a date is not too far into the past or future. You probably want to validate the date when it changes and when the form is saved (since if it alerts that the date is invalid and the user presses save again it will allow the invalid date to be saved).

Adam Stoller

I found the problem in the regex - near the middle of it you'll see:

|(02-((0[1-9])|(1[0-2])|(2[0-8]))))-

That should be:

|(02-((0[1-9])|(1[0-9])|(2[0-8]))))-

I'll fix the KB shortly.

--fish
(Interwoven Senior Technical Consultant)

JackIntheBox

Thanks much, John and fish. The new regex worked perfectly.