Date Problem

[LSM1604]

Hello,

I have a form which puts a date into a cell, however I have a slight problem with it...

If the date within the form says 15/08/2010, then 15/08/2010 is displayed in the cell.

However, if the date within the form says 06/08/2010, then 08/06/2010 is displayed in the cell.

Why does the cell display the correct date if it is after the 12th in the month, and the wrong date (back to front) if it is the before the 13th of the month?? This doesn't make sense to me?

Any help would be much appreciated.

LSM1604


Below is a small section of my code:

    Range("Q5").Select
    With ActiveCell
   .NumberFormat = "dd/mm/yyyy"
   .Value = TextBox_DateHidden.Value
    End With

 

[Andrew Poulsom]

Do it like this:

.Value = DateValue(TextBox_DateHidden.Value)

VBA is US-centric when it comes to dates, unless the day and month aren't ambiguous. The DateValue function is locale aware.

 

[LSM1604]

Thank you, it works perfectly

LSM1604