How to filter CreationDate

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi all
I try to find a message by this line
Set OlMail = OlItems.Find("[CreationTime] = 05/27/2004 08:21:33"
and get the message: Filter cannot be parsed; error at "8
I assume I need a certain format but cannot find which is appropriate. Any ideas
TIA, Norbert Meiss
 
Thanks, Ken
I wonder why a search with an exact time (without seconds) does not work
strSearch = "[ReceivedTime] = " & Chr$(34) & Format(recEMA!EMA_ReceivedTime, "ddddd hh:mmAMPM") & Chr$(34
while a combination from >= exact time AND <= exact time + 1 minute does
strSearch = "[ReceivedTime] >= " & Chr$(34) & Format(recEMA!EMA_ReceivedTime, "ddddd hh:mmAMPM") & Chr$(34) & "
AND [ReceivedTime] <= " & Chr$(34) & Format(DateAdd("n", 1, recEMA!EMA_ReceivedTime), "ddddd hh:mmAMPM") & Chr$(34
Anyway I got it to work

Regards, Norber
 
Back
Top