Converting a date to Hex for use as password

R

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
 
R

Rick Brandt

RIP said:
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")))
Click to expand...

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