KimRavizza
6 years agoQrew Cadet
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
------------------------------
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
------------------------------