convert 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.
Any ideas will be greatly appreciated.
Thanx in advance
Walter

 

[Allen Browne]

Try:
Hex(CLng(Format(Date(), "mmddyyyy")))