Comparing Dates Problem

Last activity on October 1, 2023 - 11:21 22k Views 3 Replies Reports & Macros

Herman Kantushov on October 26, 2015

Hi guys,

I managed to get user's input and format the dates, however when I try to compare the dates (using a couple of methods) I receive wrong values. )

Ideas?

Attachments

3 Replies

Ariene Kroeze on October 26, 2015 - 11:42

see next code:

I hope this helps.

Kind regards, Ariene

or register to reply.

Ariene Kroeze on October 26, 2015 - 11:46

I beg your pardon, the picture is almost unreadable.

I advise you to use for the comparison the date function date.valueOf().

again, regards, Ariene

or register to reply.

Herman Kantushov Author on October 26, 2015 - 13:20

Seems like it worked.

Thank you!

or register to reply.

There are currently no upcoming events.