|Ok what Im trying to do sounds very simple... I just cant get to the right format.|
Lets say I have a date like 8/2/12 or 12/31/12
I need to make an if condition where if the date is after lets say 10/31/12 the user would get a pop up error message saying to use a current version.
Im just trying to force users to keep up with the current forms that I realize to them, caus ethey just keep using the old versions caus ethey are lazy as hell.
I know how to make the if condition and the error pop up message.
I just need Excel to convert the date into numbers like 8/2/12 = 41123 in the background without showing it.
So if the date is 10/31/12 = 41213 I want excel to stop the process and give an error message to the user.
CurrentDate = 08/02/12
If (CurrentDate) > 41213 then
MsgBox "Dude use the current form"
About 4 pages of code
Note: when I take the date from another screen it comes as "08/02/12"
Always 8 characters
Thanks in advance!!!