Unable to interpret time or date – where is it? ScanEZ to the rescue!

Unable to interpret time or date – where is it? ScanEZ to the rescue!

You know the problem: a user wants to save a document, gets a prompt in his face with “Unable to interpret time or date”, or whatever the other validation error, but he didn’t make any mistake. It’s been there since somebody else managed to save that document (probably due to code that saved it without validation).

What field throws the message? With a lot of trial and error, you may be lucky and find it. Or, you can do what I did this morning: I’m the happy owner of ScanEZ, Ytria’s amazing piece of software, and I found out it’s pretty easy to spot the error.

  1. Open the rotten document in ScanEZ: you get an image of all fields and their values.
  2. The first column displays the field type (Date, String,…)
  3. If a field throws errors, it gets the type “Error”
  4. Now, if you sort on field type, you can pretty easily spot the error field.

error in scanez

To solve the problem:

  1. Delete the field.
  2. Save the document again in Lotus Notes; the field is recreated (since it exists on the form).

That’s it!

Oh, and if you(r company) doesn’t use ScanEZ yet, you should really check it out, by the way ;-).

6 Comments

  1. 我来看看,欢迎不欢迎?

    Reply
  2. 不错,不错,看看了!

    Reply
  3. 看看您的博客!

    Reply
  4. 年中快乐!

    Reply
  5. 博客不错,嘎嘎!

    Reply

Leave a Reply to yx87x7 Cancel reply

Your email address will not be published. Required fields are marked *

− 1 = 1

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>