I have two date fields that are linked into one master spreadsheet from two
different sources. Once in the master spreadsheet they need to be compared.
When looking at the sources, they appear to both be true dates with a date
format. But when I try to compare them, they do not match. I have tried to
concantenate each with another field (a corresponding hour). When I perform
the concantenation I find that the two dates behave differently. One stays
in mm/dd/yyyy format, and the other becomes the Excel representation of a
date (ie 37989 = 1/3/2004). So then I added 'TEXT' logic to the dates. They
still will not compare properly. What else can I try?