Converting a date to Hex for use as password

G

Guest

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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

convert date to hex for use as password 1
how to use variables in queries 7
Generic Password 15
How create & use list of date-based tasks to use on each new case? 4
use a worksheet as a form to collect data 4
Converting Date and Time to a standard number 2
Access Access Eliminate Blank Query Results 1
Message Box to Display a count of Records 3

Top