Conversion from string (item.headers("date")) to type 'Date' is not valid

[Carlos_Andres_Garcia (Carlos Andres Garcia Tobon)]

Hi friends

Please help me with this issue. This is my case

I need to get a mails list from gmail, I am using “Get IMAP Mail Messages”, from this list of mails I need to catch every mails sended yesterday, for that I am using for each and for every item I am getting the sentence item.Headers(“date”) for know the receive’s date. In other variable type datetime I am catching the actual date “NOW”.

As item.Headers(“date”) is string, I need to convert to date for comparation with now date, here is my issue because the mails have different type of date, for example, some mails come with date like:

“Sat, 25 Jan 2020 03:45:30 -0500”-> this apply Cdate(item.Headers(“date”)) and convert well

“24 Apr 2020 10:42:42 -0500” → this apply Cdate(item.Headers(“date”)) and convert well

but whith next date appear a error “Wed, 06 Nov 2019 16:23:23 +0000 (UTC)” appear this error: Assign: Conversion from string "Wed, 06 Nov 2019 16:23:23 +0000 " to type ‘Date’ is not valid.

I have tried to convert for many way but I can´t to goal

I hope you can help me pelase and I am sorry for my english,

I have read these topic:

How to get gmail date which is (Created at:) Datetime in IMAP

Hi All, I need to get (“Created at:”) datetime from gmail anyone knows how to achieve it? I do not want to use item.header(“Date”).tostring as it do not give me local time sometimes. Plus I am using IMAP. Please help. Regards Vaneet

IMAP Date Time Header showing different date format and not recognise

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)…

but until now nobody have answer for that.

[AndersJensen]

Hey Carlos, change your assign to this:

DateTime.ParseExact(fechacorreoaux1,“ddd, dd MMM yyyy H:mm:ss zzzz (UTC)”,system.Globalization.CultureInfo.InvariantCulture)

and it will work like a charm

[Carlos_Andres_Garcia (Carlos Andres Garcia Tobon)]

Hi Anders

Thanks very much for you answer, I have tried like you tell me but the issue persist:

[AndersJensen]

Hey Carlos, can you set your input to “Wed, 06 Nov 2019 16:23:23 +0000 (UTC)” and see if it still gives an exception? Or check if it still that date that gives you an error. If not, then your input data is changing and we gotta solve for that.

[AndersJensen]

Hey Carlos, I’ve attached the code and it works perfectly from my side.
Main.xaml (4.5 KB)

[Carlos_Andres_Garcia (Carlos Andres Garcia Tobon)]

AndersJensen
thanks you man, I was commited a mistake, I was using: " " and you ” ” in the sentense