Converting a date to Hex for use as password

[RIP]

How can I convert todays date to hex for use as password validation??
For example, todays date 11202006 = AAEDD6
If password entered = AAEDD6, and today's date = November202006, then allow
access, else exit sub.

I was given the following to try, but I am not quite clear on the syntax to
use in a IF Then Else statement:
Hex(CLng(Format(Date(), "mmddyyyy")))

Thanx in advance
Walter

 

[Rick Brandt]

How can I convert todays date to hex for use as password validation??
For example, todays date 11202006 = AAEDD6
If password entered = AAEDD6, and today's date = November202006, then allow
access, else exit sub.

I was given the following to try, but I am not quite clear on the syntax to
use in a IF Then Else statement:
Hex(CLng(Format(Date(), "mmddyyyy")))

If PasswordEnteredByUser = Hex(CLng(Format(Date(), "mmddyyyy"))) Then...