Format table cells with?

[Jeanne A. E. DeVoto]

At 8:09 AM -0800 2/2/2006, Bill Vlahos wrote:
>Is there a way to have it flag when what was entered isn't a valid 
>date? For example February 32, 2006 or Fuberry 2, 2006.

I don't think there's an easy way, no - you'd have to modify the 
revTable frontscript to add this. I think this modification will work 
(WARNING! NOT FULLY TESTED! ABANDON ALL HOPE YE WHO ENTER HERE! 
BACKUP! BACKUP! OK!):

In the revDateFormat handler, you'll see this:
   if (tValue is not empty) and (tValue is a date) then
    put revDateDisplay(pPrefixList,tValue,tgroup) into tFormattedValue
    revWriteCellValue pObject,txcell,tycell,tFormattedValue
  end if

Substitute this:
  if (tValue is not empty) then
    if (tValue is a date) then
      put revDateDisplay(pPrefixList,tValue,tgroup) into tFormattedValue
      revWriteCellValue pObject,txcell,tycell,tFormattedValue
    else -- not a valid date, and not empty
      revWriteCellValue pObject,txcell,tycell, \
         "<p><font color=" & quote & "red" & quote & ">" & tValue & "</p>"
    end if
  end if

If the value entered isn't a date, this leaves it unchanged but turns it red.
-- 
jeanne a. e. devoto ~ revolution at jaedworks.com
http://www.jaedworks.com