| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Date Conversions
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Date Conversions
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 --- Message posted from http://www.ExcelForum.com/ |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| conversions | Excel Worksheet Functions | |||
| Conversions | Excel Worksheet Functions | |||
| Date conversions | Excel Discussion (Misc queries) | |||
| unwanted date conversions | Excel Worksheet Functions | |||
| Date Conversions from UTC to EST | Excel Worksheet Functions | |||
Linear Mode
