http://qs321.pair.com?node_id=167915


in reply to Lotus Notes and datetimes

Here's an example of extracting a date from an email message in Lotus Notes:
use strict; use Win32::OLE; # Open the email database in Lotus Notes my $notes = Win32::OLE->new('Notes.NotesSession') or die "Can't open Lotus Notes"; my $database = $notes->GetDatabase("",""); $database->OpenMail; # Get a list of all of the documents in the Inbox # (Use single-quotes to protect the dollar-sign) my $view = $database->GetView('($Inbox)'); # Get a Notes document my $doc = $view->GetFirstDocument; # The "Created" timestamp is stored as an object # via a property named "Created" my $create_date = $doc->{Created}; # To convert this to a usable date like "09/11/2001", # call the "Date" method on this object my $date = $create_date->Date;
I worked this out via the debugger: I created the object $doc and typed:  m $doc

Aha! The document has a "Created" property. I saved this into $date and typed: x $date

The debugger responded that $date is an OLE object. So I typed: m $date and I saw that it has a "Date" method. Just play around in the debugger and you'll find lots of cool stuff.

buckaduck

Replies are listed 'Best First'.
Re: Re: Lotus Notes and datetimes
by Cycle Boy (Initiate) on May 21, 2002 at 07:51 UTC
    Works a treat.

    Thanks for that.

    Cheers,
    David