Heuristic Password

Hello,

I've been give a formula for creating a password, but can't seem to figure out how to make it work in QuickBase. Here is how it must work:

1. Take the 1st 4 digits of the current date and the first two digits (hour) of the time
2. If the number of the hour is odd, add 9 to every digit and subtract 10 if the resulting number is greater than 9
3. If the number of the hour is even, add 5 to every digit and subtract 10 if the resulting number is greater than 9
4. Add 2 zeroes to the beginning of the number

Examples:

Today at 12:06 pm

1. 041912
2. N/A
3. 596467
4. 00596467

Today at 13:06

1. 041913
2. 930802
3. N/A
4. 00930802

Do I need to create a separate field for each digit and then concatenate them at the end? How do I strip out each digit? 

I'm thinking that for the first digit I would use a formula like: Left(ToText(Today()),1), but how do I get the rest of the digits split out?

Once I get the numbers split out, how do I determine if they are odd or even?

All thoughts and suggestions are greatly appreciated!

Thank you,

Kim

------------------------------
Kimberley
------------------------------