Copy link to clipboard
Copied
I am looking for a script that will allow me to place 3 sets of double digits, such as, 10 12 03. The three digits are the number of years, months, and days. I used the date custom to achieve this, but it gets me a date box. This is not what I am looking for. I just want to be able to enter the number of and not the year of, if that makes sense. The box should only have numbers entered in it no text. Is this possible?
Copy link to clipboard
Copied
You can do it using the following Format option: Special - Arbitrary Mask - enter "99 99 99" (without the quotes).
However, this will not validate that the numbers are a valid date. You could enter "45 21 99", for example.
If you want to validate that you would need to use a custom Validation script.
Copy link to clipboard
Copied
Thank you, I will attempt to use this to see how it works out for us. By chance would you know the scripted I would need to use in case this does not work out the best?
Copy link to clipboard
Copied
Yes, I would be able to help you out with the validation script, if you really need it.