Extract Current Hour emails using Get exchange mail activity

[SudhaRajesh (Sudha Rajeshkumar)]

Hi,

We have a requirement where we need to Extract Current Hour emails using Get exchange mail activity. Using the below, we can filter today’s email. But we need to extract emails received in current hour.

mailMessagesList.Where(Function(x) DateTime.ParseExact(x.Headers(“Date”), “MM/dd/yyyy HH:mm:ss”, Nothing).Date.Equals(DateTime.Now.Date))

Thanks in Advance.

Thanks,
Sudha.

[Palaniyappan (Palaniyappan P)]

Hope this thread would help you resolve this

Is there any way I can read only last 1 hour mails in gmail.(Urgent)

You can do something like this mailDate = cDate(item.Headers("Date")) where item is a mailMessage This will give you the date of the email, then you can use if condition and write something like this if (mailDate < DateTime.Now AND mailDate > DateTime.Now.AddHours(-1)) { then do your stuff} Working fine at my end Thanks, Prankur

Cheers @SudhaRajesh

[SudhaRajesh (Sudha Rajeshkumar)]

Thank you Palaniyappan!

It is working as expected.
To extract last 60min emails: cdate(item.Headers(“Date”)) < datetime.Now and cdate(item.Headers(“Date”)) > datetime.Now.AddHours(-1)

To Extract Current hour Emails: cdate(item.Headers(“Date”)).ToString(“hh”).Equals(datetime.Now.ToString(“hh”))

Thank you!