Report

Comapare two columns containing date and time [Closed]

Ask a question Andnil - Last answered on Nov 20, 2009 at 06:04 AM by Andnil
Hello,

I would like to comapare two columns containing date and time data to is if the match. If the don't, i would like to return a value i.e. "1" to the same row in another colum for filtering later on.

Thanks in advance!

Kind regards
Anders Nilsson
Helpful
+1
plus moins
Here is an example of what I'm trying to do:

A B C
06/15/2009 11:40 PM 06/15/2009 11:40 PM
06/15/2009 11:50 PM 06/16/2009 12:00 AM
06/16/2009 12:00 AM 06/16/2009 12:10 AM

If the date i time in column A dont match the date and time i column B i would like to have a value of some kind returned to column C:

A B C
06/15/2009 11:40 PM 06/15/2009 11:40 PM
06/15/2009 11:50 PM 06/16/2009 12:00 AM 1
06/16/2009 12:00 AM 06/16/2009 12:10 AM 1
Was this answer helpful?  

Member requests are more likely to be responded to.

Members can monitor the statuses of their requests from their account pages.

A CCM membership gives you access to additional options.

Not a member yet?

Sign up now. It takes less than a minute and is completely free!