How to compare email date with date in excel

[dhanashree22 (Dhanashree)]

hello all, I have date in excel want to compare with email date how to do it?
I have date in excel stored in variable. In If condition item.Date> lastdndt

[Pradeep_Shiv]

Hello @dhanashree22 ,

You can get the dates from excel in for each row loop and try like this in IF condition
Cdate(Item).ToString(“ddMMyyyy”)>Cdate(row(""dateColumnName).ToString).ToString(“ddMMyyyy”)

[Yoichi]

Hi,

Roughly, the following will work.

However it might be needed to use ParseExact method.(depends on datetime format)

Regards,

[dhanashree22 (Dhanashree)]

Hello ,Mam
here I want latest new mail date. I write the formula in write cell as
item.Date.ToString But Runtime bot gives ans in excel as Tue, 09 Nov 2021 13:20:17 +0000
but I want like 09-11-2021 in excel. so what formula should I write in write cell

[Yoichi]

Hi,

Can you try the following expression?

DateTime.Parse(item.Date).ToString("dd-MM-yyyy")

Regards,

[dhanashree22 (Dhanashree)]

Thank you Mam, its work fine…Thank you so much