Skip to main content
T
Tei28204474v2l3
Known Participant
October 23, 2023
Question

Text box with 3 sets of double digits

  • October 23, 2023
  • 1 reply
  • 414 views

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?

    This topic has been closed for replies.

    1 reply

    try67
    Community Expert
    try67Community Expert
    Community Expert
    October 23, 2023

    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.

    T
    Tei28204474v2l3Author
    Known Participant
    October 23, 2023

    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?

    try67
    Community Expert
    try67Community Expert
    Community Expert
    October 23, 2023

    Yes, I would be able to help you out with the validation script, if you really need it.

    Terms & ConditionsAccessibility statement
    Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices