I would say "December 20th, Nineteen Eighty (not my real birthdate). You're welcome to state it your way.The terms Most Significant digit and Least Significant Digit are well defined.
If someone asks when you were born would the year or the day be more significant?
In the UK we also use dd/mm/yyyy and I get this in the immediate window?Please tell me what changes need to be made to the above code in order to achieve the goal?
? date = #12/24/2019# True
? format(date,"dd/mm/yyyy") = #12/23/2019# False ? date = #12/23/2019# False
?format(Date,"mm/dd/yyyy")=#12/24/2019# True ?Date=#12/24/2019# True
Yes I realise that, and I thought that was the point he was making...that he expected that code to be false and not show the greeting.Yes I realise that, but Kundan posted that today?
If Date > #12/31/2019# Then MsgBox " HAPPY NEW YEAR ", vbExclamation, "Greetings:" End If
If Date >= #1/1/2020# Then MsgBox " HAPPY NEW YEAR ", vbExclamation, "Greetings:" End If