Comparing two dates error

Help
1

Hi,

I have a problem with comparing two dates. I am trying to compare mailreveivedtime and mailLastReadingTime in condition with > and then I tried to compare these two dates with CompareTo but it also does not work

CompareDates
CompareDates1276×667 86.6 KB

Please, can somebody help me? Thanks

Matej

2

CompareTo return value -

  • Less than zero : If this instance is earlier than value.
  • Zero : If this instance is the same as value.
  • Greater than zero : If this instance is later than value.
3

@mkriznjak

you can use
DateVariable1 >= DateVariable2

returns Bool Value

4

I tried that but I always get -1 as result.

5

Hello,

Are both of your variables DateTime ?
If yes, try and use DateTime.Compare like this:
DateTime.Compare(mailreceivedtime, mailLastReadingTime);

6

In attachment is project. Maybe the problem is with reading values…

Email_and_attachment_parser.xaml (16.5 KB)
Last_reading_time.xlsx (9.1 KB)

7

Hi guys, everything is working when I store this value in *txt file…

8

Hi!
Please refer to this one: Unable to compare date - #2 by aksh1yadav
Thanks!

1 Like