IMAP Date Time Header showing different date format and not recognise

Help
1

Hi All,
I am getting issue when I am getting date from Gmail through IMAP (item.headers(“Date”)) then it is giving me Datetime format differently eg (Mon, 23 Dec 2019 12:32:40 -0800 (PST)) with my system datetime zone.
and when I am trying to convert it to date time it gives error that system did not recognize as datetime neither it is able to change timezoneifo . Date can be in any timezone so how can i easily convert it to this datetime to my system datetime zone(like PST, CST,UTC, GMT etc). Do i need to figure out every timezone and create criteria or any easy way?
Please help.
I know in outlook activity there is filter where we can set this criteria easily.
Regards
Vaneet

1 Like
2

Hi

if possible can i see the expression used to convert the date
@vaneet_kumar

3

@Palaniyappan
I am using Convert.ToDateTime(item.Headers(“Date”))

4

Use this:

Datetime.parseexact(item.headers("Date").ToString,"ddd, d MMM yyyy hh:mm:ss zzzz (UTC)",System.Globalization.CultureInfo.InvariantCulture)

5

@bcorrea @PragmaticProgrammer
I did same but still saying system did not recognize valid datetime
Can you help

6

ok, so no luck for you, you need to do manual parse of that string and after a datetime.parseexact…

7

@bcorrea
I am afraid still showing error system format exception. Also i need to change this date time zone equivalent to my timezone…so do i need to put condition for recognizing each timezone?

8

yes, maybe you will need real advanced stuff if you really need to parse this:

9

Thanks @bcorrea for your reply.
fetch item.headers(“Date”) then getting it convert that is very lengthy…I found out there is also created at: datetime in show original .which fulfill my criteria. I do not know how to fetch that date can you help if i can able to fetch that text thing would be pretty easy. Thanks again))

10

Where is that field present?

11

when you see show original by clicking right corner button contain 3 dots there you would find field

Show original Created at
Show original Created at886×590 58.1 KB

Thanks))

12

yes, but that is using the web browser right?

13

yes can we get that date field(Created at) in UI path somehow?
or
where we can put like in outlook
[ReceivedTime] > ’ " + Now.AddDays(-1).ToString(“MM/dd/yyyy”) + " ’ AND [ReceivedTime] <= ’ " + Now.Date.ToString(“MM/dd/yyyy”) + " ’ “).

14

imap does not have filters, but are you saying all this time you dont need the time?

1 Like
15

@bcorrea
I need both date and time , i was just trying to find out if we can convert timezone it to our system time zone then it looks tedious work…
so i am figuring out to fetch datetime by (created at) anyhow?
let me know if we can work out by fetching datetime though (created at) in uipath

again Thanks for replying .