Date Conversions

  • Thread starter Thread starter Josh Sale
  • Start date Start date
J

Josh Sale

I have an Excel 97 - 2003 project in which I need to perform a date
conversion. I have two dates that come from the FileDateTime function that
I want to compare (i.e., which is newer). FileDateTime (at least on my
system) returns a date in a format like "1/28/2004 2:24:40 PM".

Anybody have a suggestion on how to convert that string representation of a
date into a format that can be used for comparison?

TIA,

josh
 
you can try cdate function or the format function works good for me
sometimes.

format(strValue, "mm/dd/yyyy HH:MM AM/PM") then make sure you format
the other date string the same way.

Keith
www.kjtfs.com
 
Back
Top