arrun
12-31-2012, 02:44 AM
Dear all,
I am facing a strange problem with the Date calculation in VBA. To specify my problem, please open my attachment and run the Calc() macro.
Now if I point to the code in VBA 'Format(Worksheets("Sheet1").Cells(23, 1), "mm/dd/yyyy") > Today_Date', I was expecting to get 'TRUE' instead I got 'FALSE'.
Can somebody point me where I am going wrong?
Thanks and regards,
I am facing a strange problem with the Date calculation in VBA. To specify my problem, please open my attachment and run the Calc() macro.
Now if I point to the code in VBA 'Format(Worksheets("Sheet1").Cells(23, 1), "mm/dd/yyyy") > Today_Date', I was expecting to get 'TRUE' instead I got 'FALSE'.
Can somebody point me where I am going wrong?
Thanks and regards,