modify date from 1/1/0001 to 1/1/1900 ?

[davtro]

Hi, migrating some Lotus Notes 6.5 DBs I found lots of dates that are
set to 1/1/0001 12:00:00 AM. The new system only supports dates
starting from 1/1/1900 12:00:00 AM, so I need to change the year 0001
to 1900 for several fields.

What is the easiest way to change a field from 1/1/0001 12:00:00 AM to
1/1/1900 12:00:00 AM for all the rows in a nsf?

Is there a tool that can help me do this or do I need to learn some
scripting?

thanks
David

[davtro]

Ok, I found some tools that can help edit fields in a notes db, like
NoteMan and ezScan.

As Notes newbie I'm having difficulties with the correct Select
statement to select fields with a specific datetime value.
I would like to select fields that have changedDate set to "01/01/2000
12:00:00 AM"

This doesn't work:
Select (@GetField ( "changedDate" ) = "01/01/2000 12:00:00 AM");

Do I need to compare dates with some other operand than "=",
please?

The display value "01/01/2000 12:00:00 AM" seems dependent on windows
locale so I guess it is not the actual stored value in DB?

thanks