Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Dates - Days and months switching around
Hello, I'm building a solution that is heavily dependant on dates, the
problem I'm having is in certain situations it's switching the day and month around. I'm from the UK so we use dd/mm/yy - where as Americans use mm/dd/yy so I'm guessing it's somehow reverting to American style in VBA somehow. It's a little bit confusing as I do lots of date checks and sometimes it'll work correctly and other, seemingly random times it'll switch around. I'm just wondering if there is a way to specifically make sure - to force the little swine - to treat all dates as declared as in my regional settings. Any help given would be appreciated, otherwise I may have to take a boomstick to the machine. :) Nate |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Dates - Days and months switching around
cast the date
CDate(Mydatevalue) -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "NateBuckley" wrote in message ... Hello, I'm building a solution that is heavily dependant on dates, the problem I'm having is in certain situations it's switching the day and month around. I'm from the UK so we use dd/mm/yy - where as Americans use mm/dd/yy so I'm guessing it's somehow reverting to American style in VBA somehow. It's a little bit confusing as I do lots of date checks and sometimes it'll work correctly and other, seemingly random times it'll switch around. I'm just wondering if there is a way to specifically make sure - to force the little swine - to treat all dates as declared as in my regional settings. Any help given would be appreciated, otherwise I may have to take a boomstick to the machine. :) Nate |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Dates - Days and months switching around
Cheers Mr.Phillips, I shall kick myself for not thinking of that and also
taking up your time, but thank you for your speedy reply. "Bob Phillips" wrote: cast the date CDate(Mydatevalue) -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "NateBuckley" wrote in message ... Hello, I'm building a solution that is heavily dependant on dates, the problem I'm having is in certain situations it's switching the day and month around. I'm from the UK so we use dd/mm/yy - where as Americans use mm/dd/yy so I'm guessing it's somehow reverting to American style in VBA somehow. It's a little bit confusing as I do lots of date checks and sometimes it'll work correctly and other, seemingly random times it'll switch around. I'm just wondering if there is a way to specifically make sure - to force the little swine - to treat all dates as declared as in my regional settings. Any help given would be appreciated, otherwise I may have to take a boomstick to the machine. :) Nate |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Dates - Days and months switching around
Being from the UK too, I suffer that VBA 'feature' all the time.
-- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "NateBuckley" wrote in message ... Cheers Mr.Phillips, I shall kick myself for not thinking of that and also taking up your time, but thank you for your speedy reply. "Bob Phillips" wrote: cast the date CDate(Mydatevalue) -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "NateBuckley" wrote in message ... Hello, I'm building a solution that is heavily dependant on dates, the problem I'm having is in certain situations it's switching the day and month around. I'm from the UK so we use dd/mm/yy - where as Americans use mm/dd/yy so I'm guessing it's somehow reverting to American style in VBA somehow. It's a little bit confusing as I do lots of date checks and sometimes it'll work correctly and other, seemingly random times it'll switch around. I'm just wondering if there is a way to specifically make sure - to force the little swine - to treat all dates as declared as in my regional settings. Any help given would be appreciated, otherwise I may have to take a boomstick to the machine. :) Nate |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Number of Months and Days between 2 dates? | Excel Worksheet Functions | |||
Number of years/months/days between 2 dates | Excel Worksheet Functions | |||
how many months and days between two dates? | New Users to Excel | |||
difference between two dates in years, months and days. | Excel Worksheet Functions | |||
How do I calculate how many days in which months given two dates . | Excel Programming |