Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
a simple question
I had a similar problem.
The first set of dates being 01-05-2003 to 12-05-2003 in 2002 may be getting intrepreted as "mm-dd-yyyy" format, rather than "dd-mm-yyyy" as you appear to be expecting, therefore making this Jan 5, Feb 5 etc to Dec 5. Of course there is no 13th month in our calendar (there is in some), so VBA treats 13-05-2003 as a string - not a date at all. The obvious answer is to treat the incoming record as a string, and use Left, Mid & Right string functions to populate the DateValue(dd,mm,yyyy) function in VBA. Therefore leaving no room for international misunderstandings to creep into your coding. Regards Dave "Question deleted from response" |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Simple Question - Sum If?? | Excel Worksheet Functions | |||
Simple question | New Users to Excel | |||
IF formula-simple question; simple operator | Excel Discussion (Misc queries) | |||
Simple Simple Excel usage question | Excel Discussion (Misc queries) | |||
Simple Question | Excel Programming |