How to compare email date with date in excel

Help Studio
, ,
1

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

2

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

3

Hi,

Roughly, the following will work.

img20211112-7
img20211112-7593×674 11.9 KB

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

Regards,

4

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

5

Hi,

Can you try the following expression?

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

Regards,

1 Like
6

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

1 Like
7

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.