I download a report from an online query I have no access to, meaning I
can't manipulate the query. The query returns reports with the date
they were completed in a yyyymm format (or so I thought). I maintain a
log as well and want to compare the two lists. When I run a comparison,
I convert my dates to yyyymm but the vlookup function doesn't work
because the dowloaded report only looks like its in a yyyymm format.
For instance, the dowloaded report looks like: 200312, which is Dec
2003. But when I convert it to date yyyymm it changes to244806 so it
is in some other format that won't allow me to convert it so that I can
compare the two lists in automation. How do I get the dowloaded 200312
to look the same way in a date format?

Thank you.


--
badpuppie
------------------------------------------------------------------------
badpuppie's Profile: http://www.excelforum.com/member.php...o&userid=15453
View this thread: http://www.excelforum.com/showthread...hreadid=375721